I am new to salesforce and have a requirement and want to know, how to approach towards it.
There are three custom objects "Websites_c" , "Users_c" & "Staus_c"
In Websites_c, I have one custom field and it’s having lookup relationship to "users_c" object.
Now, once the records are added to these two custom fields, I want to display the result in the third custom field ("Staus_c") in a table format.
Please guide me with this issue and how I approach to this kind on scenario.
Adding a new ans don't have an option to reply to the previous comment. For your requirement, one approach could be as follows:
Create a trigger on Website object as it is the child in the lookup relation. This trigger would run for after insert instances so that only when the record is successfully saved, will you create a record for status object.
you'll have to query and get the record from user object using the relationship field. then create an instance for status object and when the trigger runs copy the relevant field data in the status object. And then insert the status record.
some best practices for trigger: Don't execute dml operations or queries in for loop. And try to bulkify the trigger.
Would suggest you give it a try and let me know if it works. if not then could work on the code. any doubt let know.
