Skip to main content
Question

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

  • May 5, 2021
  • 0 replies
  • 73 views

Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------