Is it possible to populate a parent record text field with data (text field) from a related child record? Basically Populate [Text field A] on the Parent Record.....with the data found in [Field B] located on the related Child record.....When [Field C] on the Child Record is Checked....otherwise leave [Text field A] on the Parent Record "blank" Thanks is advance for help
I think yes - use client-side API (chapter 7).
Pavel,
Thank you for the reply. Can you provide any examples? I'm new to Rollbase....this would be a BIG HELP...if I can accomplish....thank you.
Pavel,
In reviewing chapter 7...I found the following...
rbf_getRelatedFields(relName, id, fieldName, callback)
This method retrieves the values of selected field for records related for a selected Rollbase record.
Is the API query I would use? If yes, can you give me an example of the code.....I would use to make the API call.....I'm new to Rollbase....I really appreciate your help.....
thanks
Yes, this should work.
Hi,
Try using a trigger on the Child record on create/update.
Trigger Type: Update Field Value
Object to update: Parent Object -- Look for this in the dropdown
Field to update: Parent Text field A -- Look for this in the dropdown
Formula Body:
As said by Pavel in a different post, make use of the dropdown helpers on top of the formula body so that you don't get any wrong syntax calls on your tokens.
Using this method on the Child record would lessen your code on the parent record since logically it should be the Child updating the Parent in this scenario.
Just make sure that on the child object, the Parent Lookup/Record should be required. If it is not, you will have to add additional handling to avert errors ^_^
Piscoso Martin
Rollbase PH
Martin,
Yeeeee Hiiiiii!!!!!!! Thank you for your help. it worked.... you da man
Thanks Martin!