I have spent days trying to get this to work, but I cannot get it to work. I have a flow that triggers on a zoho form submission. This form has a field called "Employee_ID" on it. I need to fetch the creator record and retrieve the record ID so I can then update that record after some other actions occur.
this code retrieves the record:
- string GetEIDRecV2(string EIDNum)
- {
- result = zoho.creator.getRecords("owner","ta-people","Employee_Details","Employee_ID==\"9999887\"",1,1,"licensetrackingconnector");
- RecID = result.get("ID");
- return RecID;
- }
But this code will not retreive anything:
- string GetEIDRecV2(string EIDNum)
- {
- result = zoho.creator.getRecords("owner","ta-people","Employee_Details","Employee_ID==\"EIDNum\"",1,1,"licensetrackingconnector");
- RecID = result.get("ID");
- return RecID;
- }
EIDNum is a set variable box in the Flow. Even in testing if I enter 9999887 it retrieves blank record. If I hardcode the EIDNum in the script it will work.
Second problem is when I retrieve the record with the hard coded EIDNum I cannot get it to output the Record ID that is returned so I can use it in the rest of the flow.
Any help would be appreciated.