Hi Everyone,Looking for some help with improving an automation that I've used to create a variable amount of records in a child table and link it to the parent table based on inputs in the parent table. Here is the code that has worked. let parenttb...
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’ve found the need for an Eval() (Evaluate Function) that would allow you to have a different formula for each record in a table. For example, if you have a field called Formula Text with the following data for the first 3 records:
TRIM(UPPER({Input...
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 @Sho,Thanks for your response! Unfortunately my coding experience is fairly limited (I can understand the logic but syntax gets me every time). I've tried adding breakpoints using 'debugger;' but code continues to error out at the same place. T...
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...
