Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with update record automation

Topic Labels: Automations
6476 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Lerma1
6 - Interface Innovator
6 - Interface Innovator

Hello,
I need help figuring out what I am doing wrong. In the main table, I track daily work, and in the other table, I track inventory. There is created a link record from the main table to the inventory table. From the main table, I am selecting the available items for sale. What I would like the automation to do is find the records that I have assigned and copy the quote number from my main table to the inventory table. I know I can do a lookup the problem is that I have too many records that would have to backlog. Here is what I am trying to accomplish with the automation, but it keeps failing.

Automation

After I update that Quote Number field and select the items from the inventory table, I am triggering the automation from the checkbox field.

Main table view:
Main Table

Record matches conditions

Inventory table (Resale Items) view:
Inventory

It finds the records.
Find records

Automation fails, even though it finds the Record IDs.

Update records

10 Replies 10
ocmac
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Scott,

Thank you very much for writing this.  Now it makes sense, I am assuming since I am having the same issue it has not been resolved yet?

There has been talk about doing a JavaScript workaround, but no one has listed it anywhere I can find.  For someone who has never done JavaScript and needs the workaround, how would that be done?