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.

automation problem: incomplete value

Topic Labels: Automations Formulas
Solved
Jump to Solution
1771 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.