Conditional Posting
Custom conditions for posting records
Conditional Posting :
Post data from Google Sheets into any apps by using your own conditions.
Configure conditions
Settings
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.
Special Operators
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
Equals
Does Not Equal
Less Than
Greater Than
Less Than Or Equal
Greater Than Or Equal
Is Empty
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 a number of records ready to post.
Click post now to post the records on App.
sample output:
