I have a custom object . Whenever a record is created i have to send and email and flag the checkbox to true. But When i create the record i am getting email. But when some other person logs in and create a record using the community site emails are not going but checkbox is getting checked. Until i publish the site from their system emails are not going. But i cant sit and publish in everyone system right. What might be the issue?

Thanks in advance.

Looking for an solution ASAP

I am having an issue creating a calculation formula for one of my fields, where, originally, the code should perform something like this:
where it basically finds the how many months (their start and end dates) would the tenant be paying within a quater.

e.g. Dates for Q1 is : January 1 – March 31
the tenant only have a contract of Jan 1 - Feb 31, 2 months, then we would just do 2 *total monthly cost 

(if(Tenant__c.StartDate__c >DATE(2023,10,1),
    (if(Tenant__c.End_Date__c<DATE(2023,12,31),
        Tenant__c.End_Date__c,
        DATE(2023,12,31)))-Tenant__c.StartDate__c,
    (if(Tenant__c.End_Date__c<DATE(2023,12,31),
        Tenant__c.End_Date__c,
        DATE(2023,12,31)))-DATE(2023,10,1))
)/((date(2023,12,31)-date(2023,10,1))/3)*Tenant__c.Total_Monthly_Cost__c

But as you can see, its with hard coded dates and we would need to change it each quatre, therefore we are trying to make it "automated", the code therefore becomes:

IF(
StartDate__c >
DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)),
1
),
IF(
End_Date__c <
DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)) + 3,
1
),
End_Date__c,
DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)) + 3,
1
)
) - StartDate__c,
IF(
End_Date__c <
DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)) + 3,
1
),
End_Date__c,
DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)) + 3,
1
)
) - DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)),
1
)
) / ((DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)) + 3,
1
) - DATE(
YEAR(TODAY()),
IF(MOD(MONTH(TODAY())-1,3) = 0, 1,
IF(MOD(MONTH(TODAY())-1,3) = 1, 4, 7)),
1
)) / 3) * Tenant__c.Total_Monthly_Cost__c

which should basically perform the exact same function but including to check the current month to see from where to where/ how many month should be get as the number to times the total monthly cost.

It has been working perfectly fine the pervious 2 months until this month started, would there be anyone here who would know the anwser perhaps? Will be greatly appreciated with your helpful hand.

1. Created
2. Active
3. Drafted
4. New
5. Open

Any way to optimize it .

The formula returns a boolean which is a filter criteria for records in list view.

Formula:

OR(
    AND(
        OR(
            AND(
                OR(
                    $User.ContactCaseAccessLevel__c == 'Parent account cases only',
                    ISBLANK($User.ContactCaseAccessLevel__c)
                ),
                AccountId == $User.useraccountid__c
            ),
            AND(
                $User.ContactCaseAccessLevel__c == 'Parent and Active Child account cases',
                OR(
                    AND(
                        ISPICKVAL(Account.Account_Status__c, 'Active'),
                        Account.ParentId = $User.useraccountid__c
                    ),
                    AccountId == $User.useraccountid__c
                )
            ),
            AND(
                $User.ContactCaseAccessLevel__c == 'Parent and All Child account cases',
                OR(
                    Account.ParentId == $User.useraccountid__c,
                    AccountId == $User.useraccountid__c    
                )
            )
        ),
        TEXT($User.UserType) != 'Standard'
    ),
    TEXT($User.UserType) == 'Standard'
)