Hi All,
I need assistance understanding how lookups work in Flow Designer.
Essentially, I need to:
1. Look up all the account records where "status" is "open"
2. For each of those accounts, lookup all "general cases" records where "active" is true and "account" matches each of the accounts found in the previous lookup.
3. If "status" of lookup in step 2 is "Success" (ie there are active cases associated with any of the accounts), then update all the cases associated with each account returned and update the work notes with any comments.
4. If "status" of lookup in step 2 is "error" (ie no active cases), then perform another lookup on the customer_contact table for each of the accounts from step 1 to see if there's a contact associated with the returned accounts.
5. If "status" lookup in step 4 is "success" (ie there is a contact), do nothing.
6. If "status" lookup in step 4 is "error" (ie there is no contact), then create a new general case for each of the accounts returned.
Thank you in advance
