How select a record based on critieria?
Hi,
I'm trying to do my first Zoho Flow and I stuck with the record select. I have FLOW which updates some fields in DEAL record based on Zoho Sheet with email and some other data. I'm very happy because it works :) when I put a data into the spreadsheet,
- ZFlow fetch the data,
- fetch Contact in CRM based on the email address
- fetch a deal related to the Contact
- update the deal fields
The problem is in the 3rd step. Because a contact can have many Deals assigned. I have no idea how FLOW handles this case (the latest Deal?).
Is there any way to verify (and change to a next deal assigned to the contact if necessary) if the found deal meets some conditions (is OPEN, Product is equal ABC)?