Skip to main content
Solved

Best practise with triggering the script after record is created

  • June 28, 2021
  • 3 replies
  • 48 views

Forum|alt.badge.img+1

Hi all!

I’m developing a script that triggers when a new row is added to a table (it makes HTTP call to retrieve more data, and add to the missing columns). I’m currently using “When record is created” as a trigger, and it works well in cases where the entire row is added to the table at the same time through other automations, or copy-paste.

My problem is with written inputs. So if a user writes the data manually, the script triggers too soon, before all the columns are filled in, thus with only partial inputs to my HTTP call.

What’s the best way to overcome this? Intuitive I thought the trigger would work so that when a user is adding the row, it fires only when the focus goes away from the added row. But obviously not. :slightly_smiling_face:

Thanks for the help!

Cheers,
tommi.

Best answer by Kamille_Parks11

Author here. Sorry, I realised this is a topic for a separate Scripting app, not the Automations… Moving this to the right place…


The Scripting App functions similarly to an Automation Run a script action, but not identically. Its probably best to keep this categorized under “Automations” since you can’t do what you’re asking with the Scripting App and your question isn’t about the script anyway, its about the best possible trigger for an Automation.


Have you tried experimenting with another trigger like “When record matches conditions”? That way you can dictate that the Automation shouldn’t trigger until your fields have been filled in a certain way.

3 replies

Forum|alt.badge.img+1
  • Author
  • New Participant
  • 4 replies
  • June 28, 2021

Author here. Sorry, I realised this is a topic for a separate Scripting app, not the Automations… Moving this to the right place…


Kamille_Parks11
Forum|alt.badge.img+27
  • Brainy
  • 2679 replies
  • Answer
  • June 28, 2021

Author here. Sorry, I realised this is a topic for a separate Scripting app, not the Automations… Moving this to the right place…


The Scripting App functions similarly to an Automation Run a script action, but not identically. Its probably best to keep this categorized under “Automations” since you can’t do what you’re asking with the Scripting App and your question isn’t about the script anyway, its about the best possible trigger for an Automation.


Have you tried experimenting with another trigger like “When record matches conditions”? That way you can dictate that the Automation shouldn’t trigger until your fields have been filled in a certain way.


Justin_Barrett
Forum|alt.badge.img+21
  • Inspiring
  • 4647 replies
  • July 5, 2021

@Tommi_Holmgren Did Kamille’s solution solve your problem? If so, please mark her comment as the solution to your question. This helps others who may be searching with similar questions. Thanks!