It's annoying how such a crucial feature ends up being utterly useless and wasting me hours as I'm trying to figure out how to get the Email ID from the user I've selected within a Users Field.
This field's only purpose as of now is to assign a record's owner name automatically as the user name of the user chosen from that field OR to do logic-defying assignments involving comparisons between zoho.loginuser and other such internal values from the application.
However, there is absolutely, AB-SO-LU-TELY no way to get a string value of the Username or the Email assigned to a chosen user. None. Wanna know why? Because Deluge returns a number every time! It's been engineered to prevent the fetching of emails from a ZohoCreator user that isn't the admin nor the currently logged-in user.
Right now, I have a client that's got an application which needs to be syncing data from
ZohoCreator to
ZohoBooks' Timesheet module. One of the things I need to do is create a ZohoBooks User using a ZohoCreator's Email ID. But it makes it really hard for me to do so when the User Field's returned value is an ID from a User database which cannot be accessed.
The multiple threads I've seen involing this required functionality have all been forgotten with no replies whatsoever. So I hope this one will reach the ZohoCreator developers.
So I would like either of those things to be implemented :
- Interpret the User Fields from within a Deluge script as a collection (just like a record fetched from a form using the whole `Form [<criteria>]` dealio) that includes access to the id (what's currently returned as of now from User_field.toString()), user_name and email_address (aka email_id) that's related to the user chosen from that dropdown.
OR
- Allow to access the User database using a call like this :
- aCollectionResult = zoho.User [Email_ID == zoho.loginuserid];
Which would allow us to fetch every user that corresponds to the criterias entered. Of course, this will return either a list of collections or a single collection element which contains every values needed, like username or email_id.
Your move, Zoho.