If you’d like this tutorial in video form, click here
In this article, we’ll be talking about fetching records from Zoho Creator. It’s quite a bit easier than Zoho CRM, because you don’t have to worry about the whole API part.
How To Fetch A Record
All you need to do is specify the form name, as seen below.
In this case, we have a Staff form. You’ll see “Staff” on the second line. To the right of it, you give it criteria in the square brackets. We are fetching the Staff record that matches the chosen staff member from a lookup field (input.Available_solar_reps).
The lookup field here is Assigned Consultant.
Other Things To Try
You’re not limited to a single criterion. You can use && (and) and || (or) to refine your search.
Here’s another example for how to find Staff with a certain role:
Hope this helps you programatically fetch Zoho Creator records!