Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

Pipelines - IF list of records exists, else....

Has anyone tried using this function in Pipelines?

After a search query, I enter an if condition, and state 'If list of records exists', then 'Update Record', else 'Create Record'.

Seems simple enough, but simply put, it doesn't work. When the list does not exist, it does nothing. Simply ends the pipeline. Anyone know what I am missing?

To note, when the list DOES exist, it performs as expected.
UPDATE: Per usual, I worked on this forever and figured it out 2 minutes after posting. For others, my problem was I forgot to remove the 'For each record' branch after my search query. So of course, if there were no records, it would simply stop.

------------------------------
Mike Tamoush
------------------------------
  • Another approach is to maker an Upsert box, and then fill the box with a query and the I think its called commit the upsert to upload the records they will Merge in with existing records assuming that you have a Key field to Merge on.  An Upsert with update or insert a new row (ie add a record)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------