Help

automation problem: incomplete value

Topic Labels: Automations Formulas
Solved
Jump to Solution
764 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cnc2611032
4 - Data Explorer
4 - Data Explorer

I've set automation to create record which get value from a field when a value is entered to that field (use trigger type "when record matches condition"). But the automation is real-time triggered when the typing has not finished yet, so the getted value is incomplete. For example, enter "300" but only get "3". How do I fix it please? Thank you a lot. 

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Unfortunately, as you’ve discovered, Airtable won’t wait until you exit the text field to trigger the automation.

So you’ll need to trigger your automation differently — such as adding in a checkbox field or a single-select field — as part of the trigger conditions.

There is a good discussion on this topic here: 
https://air.tableforums.com/t/what-are-the-pros-cons-to-using-a-checkbox-vs-yes-no-single-select-vs-...

p.s. For more advanced automations where you might be using Make’s advanced Airtable automations, you’ll want to use a similar trigger, but then send a webhook to Make using a script. I discuss that in this thread: https://air.tableforums.com/t/sending-airtable-data-to-an-external-webhook-such-as-make-com/159

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Unfortunately, as you’ve discovered, Airtable won’t wait until you exit the text field to trigger the automation.

So you’ll need to trigger your automation differently — such as adding in a checkbox field or a single-select field — as part of the trigger conditions.

There is a good discussion on this topic here: 
https://air.tableforums.com/t/what-are-the-pros-cons-to-using-a-checkbox-vs-yes-no-single-select-vs-...

p.s. For more advanced automations where you might be using Make’s advanced Airtable automations, you’ll want to use a similar trigger, but then send a webhook to Make using a script. I discuss that in this thread: https://air.tableforums.com/t/sending-airtable-data-to-an-external-webhook-such-as-make-com/159

cnc2611032
4 - Data Explorer
4 - Data Explorer

Thank you for the timely and helpful reply. I'll try to change the condition to trigger.