How to set condition in creating new record only if the input value in the number field is more than a specific value?
Thank you.
Hi @PinoyAdaloUser,
I assume you try to make “create” action to be conditional, and when you select an input as a condition, it doesn’t allow you to use more/equal/less, only is equal / not equal / contains?
If yes - the reason is that inputs are treated as text fields, so no arithmetic conditions are applicable.
One of the workarounds could be:
- add a “helper” property to users collection, make it a number and call it, say, “helper_condition”
- before creating a record, add an action to update logged-in user and store the value from the input to this property
- then you can make 2nd “create record” action a conditional, and have a condition based on Logged-in User → helper_condition is less than X (X is your value).
As we’re now enjoying unlimited app actions, the only drawback will be that this action sequence will be a bit slower.
There could be also another “hacky” workaround using a different input with the formula, but it’s a bit more cumbersome.
Best,
Victor.
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.