Skip to main content
Solved

How do I get a simple selection to change base in if a number is less than X?

  • October 31, 2023
  • 4 replies
  • 29 views
E
Forum|alt.badge.img+4

Hey! Thanks in advance for the help

This is my problem, and I know how basic it sounds but I haven't been able to get this done! 

I'm creating an automation and Im setting it up so when a record matches a condition (WPM (numbers column) is not empty AND is less (<) than 35) updates a record (Candidate stage (simple selection) to --> Rejected)

But what it does is its sending all numbers (less, equal, higher) to Rejected except when WPM is empty (at least that worked) I've troubleshoot as a maniac and nothing seems to work out - Any idea?

Best answer by Arthur_Tutt

Hey @EdAirtable ! Don't worry it's not just you, happened to me too when I tried to replicated your situation. Luckily I've got a couple solutions for you that I lay out step by step in this Loom Video. 

In essence Airtable is 'too fast' and when you type '50' it registers the 5 first which is less than 35 and triggers the automation (crazy right?)

Essentially you've got 2 choices. 

If the data is copy/pasted into the cell from a form or an automation, you're fine, the automation will work as expected (try it). 

However if the data is entered manually I recommend you add a new check box field called something like 'Ready To Run?', and add as another condition to your automation that the check box needs to be checked to trigger. 

Let me know if that all makes sense ! 

4 Attachments
Arthur_Tutt

4 replies

Arthur_Tutt
Forum|alt.badge.img+19
  • Arthur_Tutt
  • Brainy
  • Answer
  • November 1, 2023

Hey @EdAirtable ! Don't worry it's not just you, happened to me too when I tried to replicated your situation. Luckily I've got a couple solutions for you that I lay out step by step in this Loom Video. 

In essence Airtable is 'too fast' and when you type '50' it registers the 5 first which is less than 35 and triggers the automation (crazy right?)

Essentially you've got 2 choices. 

If the data is copy/pasted into the cell from a form or an automation, you're fine, the automation will work as expected (try it). 

However if the data is entered manually I recommend you add a new check box field called something like 'Ready To Run?', and add as another condition to your automation that the check box needs to be checked to trigger. 

Let me know if that all makes sense ! 

E
Alexey_Gusev
Forum|alt.badge.img+25

Yes, it's a well-known issue. Also, if WPM expected to be at least 2-digit, you can add WPM>9 to conditions. But if it can be 100, 110 ... , it won't solve the problem, as it will run with 10 , 11 input data values

Arthur_Tutt
E
Forum|alt.badge.img+4
  • EdAirtable
  • Author
  • New Participant
  • November 5, 2023

Hey @EdAirtable ! Don't worry it's not just you, happened to me too when I tried to replicated your situation. Luckily I've got a couple solutions for you that I lay out step by step in this Loom Video. 

In essence Airtable is 'too fast' and when you type '50' it registers the 5 first which is less than 35 and triggers the automation (crazy right?)

Essentially you've got 2 choices. 

If the data is copy/pasted into the cell from a form or an automation, you're fine, the automation will work as expected (try it). 

However if the data is entered manually I recommend you add a new check box field called something like 'Ready To Run?', and add as another condition to your automation that the check box needs to be checked to trigger. 

Let me know if that all makes sense ! 


Thanks Arthur!!! 

The input is from a form, so I'm all clear! Highly appreciate the time you to took help 😉

Arthur_Tutt
Forum|alt.badge.img+19
  • Arthur_Tutt
  • Brainy
  • November 5, 2023

Love it! Happy to help @EdAirtable . If you found it helpful, can you do me a quick favor and mark my post as the solution? Helps to build my credibility in the community 🙂

Terms & ConditionsAccessibility statement