Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Hello all,
I found the “Create child linked records” script and it does exactly what I need to do, but I want to trigger it from within an automation, and instead of entering the number of child records, pull that information in from the input.config...
Hi All,
I’m looking for a simple/elegant solution for a formula/script that will produce what I’m looking for.
I have a text field (it will have a maximum of 9 ALPHA (uppercase only) characters in it. I’m looking for a solution that will perform the...
I’m not sure if this can be done but here’s what I’m looking for:
I have a base with two basic tables: Jobs and List
The Job Table has the following fields Job Name, Job Number, Custom Calculated Field (CCF) 1 Formula (CCF 1 Formula), CCF 2 Formula…C...
Hi @Kamille_Parks ,
So as I’ve implemented this code my use case has been updated to not only needing to create child records but to set the values of 3 additional fields in the child table as well. The 3 additional fields are a linked field to anot...
Hi @Kamille_Parks,
That was exactly what needed to be modified.
Thank you for such awesome assistance! If any one is looking here’s the final script that worked as intended:
let parenttbl = base.getTable('ListInfo');
let childtbl = base.getTable('Li...
Hi Kamille_Parks,
Thanks for the quick response! When I tried that in one of my iterations I was receiving the error:
ERROR
Error: Field "fldBZNjwVdR8Bd9uF" cannot accept the provided value.
at createChildrenLinkedRecords on line 27
at main ...
Thank you so much for your quick response, Kamille_Parks!
So I was able to get your script to work perfectly with the output showing up in the console log.
Now I’ve set up an automation when the field “FinalDiscountCodeString” is modified in the “Pro...
Hi @Justin_Barrett,
Thanks for the response. I’ve posted a product suggestion requesting the addition of the Eval() function. For now, manual copy and paste it is!
Thanks again!
Tom