Tom_H - profile

Tom_H · Jul 16, 2021

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...

Tom_H · Apr 26, 2021

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...

Tom_H · Nov 07, 2019

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...

Tom_H · Jul 30, 2021

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...

Tom_H · Jul 19, 2021

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...

Tom_H · Jul 16, 2021

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 ...

Tom_H · Apr 27, 2021

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...

Tom_H · Nov 13, 2019

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

User Statistics

User Activity

Modifying the "Create child linked Records" Script to work in an Automation

Script/Formula Solution for Extracting Contiguous Text Counts (Location Dependent)

Different Formula for Each Record in a Base

Re: Modifying the "Create child linked Records" Script to work in an Automation

Re: Modifying the "Create child linked Records" Script to work in an Automation

Re: Modifying the "Create child linked Records" Script to work in an Automation

Re: Script/Formula Solution for Extracting Contiguous Text Counts (Location Dependent)

Re: Different Formula for Each Record in a Base