Custom conditions for posting records
Conditional Posting :
Post data from Google Sheets into any apps by using your own conditions
Click on 'Conditions to execute'
Conditions to execute
Select either 'All' or 'Unprocessed', if 'All' then it will post all the rows even after a successful post. And 'Unprocessed' will check for new records to post.
By default, Apply To will be 'Unprocessed'
Select the column where you want the condition to be applied.
Select the operator from the list, by default sets to 'equals'.
Enter the value to be checked.
Click on add button to add more conditions
There are two special operators i.e. is empty & is not empty.
For special operators, you need not enter the value.
is empty - It will automatically check whether the status column is empty
is not empty - It will automatically check whether the status column is not empty
You can delete any condition by clicking the delete button as shown in the image.
Types of Operators
Does Not Equal
Less Than Or Equal
Greater Than Or Equal
Is Not Empty
Here conditions Post Now and Yes will match for Post a record
Click on execute will ask for confirmation
It will show number of records ready to post
Click post now to post the records on App