Tech support at Quickbase solved this for me.
I was searching for the existence of a record and, if that record existed, to update the original record. If the record didn't exist, to create it and update the existing record. I was trying to do it all at once - Do the search, if it is empty do A and if it is not empty do B. What I needed to do was:
Search the records
In the Do Loop for the search (which I had deleted before), update the original record, because if the Do Loop was looping, then a record must have been found.
After the do loop, at the same indention level as the search, put in the condition that If the search found nothing, then create a record and update the original.
Then everything worked. If this is confusing and you are reading this years later and want to know how I originally broke it and then how Quickbase helped me fix it, contact me about the Sunnytech App.
------------------------------
Edward Hefter
www.Sutubra.com------------------------------
