You need to sign in to do that
Don't have an account?
testuser 34379
Salesforce needs a Rollup summary of a Formula Field
I have three objects. Pilots. Pilot_cert_Links. Certifications. Pilots and Certifications both have rollup fields linked to Pilot_cert_link since this table has two Master Detail relationships each to Pilot and Certifications. Pilot rollup counts the number of certification that they have. Certification rollup counts the number of pilots who have that certification. That works fine.
However, I run into an issue while trying to make a rollup SUM on Pilot Object of Pilot_cert_linking Formula Field that links to the Certification Object and pulls the cost of each certification. I can only do ROll-up Summary of Number fields.
However, I run into an issue while trying to make a rollup SUM on Pilot Object of Pilot_cert_linking Formula Field that links to the Certification Object and pulls the cost of each certification. I can only do ROll-up Summary of Number fields.
other unrelated problem regarding lookup/autonumber as an extra field...maybe I can use Process Builder to fill the value of the primary index....but how would i verify that it's unique? I guess I can have a unique field that fills based on a formula that throws an error. SO ANNOYING i should be able to create a Primary first column index based on field names in the object
Nice now all i have to worry about is not uploading an index main field that is a duplicate and not being told and thinking it uploaded when it actually didn't --> MOSTLY BECAUSE OTHERWISE ADDING A LOOKUP/MASTER-DETAIL to THAT VALUE WHEN IT'S AN AUTONUMBER IS USELESS BECAUSE YOU HAVE TO LOOKUP BASED ON A RANDOM AUTONUMBER LIKE WHATTTTTT
Note, you can also have a field and mark it as Unique in the setup.
Issue would be populating it with a value before it is saved. So therefore a Before Trigger or a Before Flow.
So you could create the field, mark in "Unique" in the settings, and populate it with a Before Flow/Trigger.
regards
Andrew