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 number of records ready to post

  • Click post now to post the records on App

sample output: