Posts

Salesforce Fact #963 | Access formula fields from Create Records

Image
With the Winter'26 release, we can now access sobject fields from the Create records element without an additional Get records. This also works fine for local formula fields(not for cross object formula fields). This is similar to the Formulas.recalculateFormulas() function but doesn't consume any SOQL query. In this example, we have a formula field on case which calculates a date 10 days plus the Createddate. In the flow, we are creating a case record and referring the same field from the Create Record reference, it shows the value correctly. Reference:  https://admin.salesforce.com/blog/2025/improve-automation-with-winter-26-flow-features-be-release-ready Attached are the screenshots.
Post a Comment
Read more

Salesforce Fact #962 | SOQL syntax error in Get Records while using IN operator and sorting

Image
We need to be careful while using the IN operator in Get Records element along with sorting of the result by a field. If the text collection is null which is used in the Id filter, the underlying SOQL throws a syntax error. As a best practice, it is always preferred to check if the collection var is null or not. This also avoids one SOQL query. Attached are the screenshots. Reference:  https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JfvwISAR
Post a Comment
Read more

Salesforce Fact #961 | 1st monday and last friday validation in screen flow

Image
We can implement a validation in screen flow using the formula resource to select a date other than the first monday and last friday of the month. Attached are the screenshots.
Post a Comment
Read more

Salesforce Fact #960 | 2nd or 4th saturday validation in screen flow

Image
We can implement a validation in screen flow using the formula resource to select a date other than the 2nd or 4th saturday of the month. Attached are the screenshots.
Post a Comment
Read more

Salesforce Fact #959 | Issue with middle name in drill down reports

Currently if we use group by with full name in a report, the drill down feature doesn't work for the records which have middle name populated. Reference:  https://ideas.salesforce.com/s/idea/a0B8W00000GdjzQUAR/fix-full-name-filters-in-reports
Post a Comment
Read more

Salesforce Fact #958 | Exempt from Transaction Security

There is a System permission 'Exempt from Transaction Security' which bypasses the triggering of transaction security policy. It can be added to profile or permission set level and assigned to the intended users. Note: This doesn't apply to LoginEvent type. Reference:  https://help.salesforce.com/s/articleView?id=xcloud.enhanced_transaction_security_exempt.htm&type=5
Post a Comment
Read more

Salesforce Fact #957 | Password reset of new user using apex

For new users, we can use the System.setPassword() method to set a password and while logging in they would be prompted to set a new password as per the standard salesforce behavior. However, clicking on cancel would bypass that and would login to the org. This is helpful while creating multiple test users in bulk and to have same password for all instead of manually setting it for each user. Reference:  https://salesforce.stackexchange.com/questions/83345/how-do-i-create-a-user-without-asking-them-to-set-their-password
1 comment
Read more