I am able to set the value of a smart multi-select field by feeding it a comma-separated list of record IDs. But I want to set the value using a comma-separated list of sub-values of the target record.
Example:
Form A contains records with a field called "rName".
Form B contains a smart multi-select referencing records in form A called "mvFormA". I can set these values by feeding that field a comma-separated list of entry IDs such as
mvFormA=4cd2a64f-ef16-4e54-95eb-e4c68dca8845, 130b391a-9910-40d1-8682-c12a917f446f, aeb32d51-9953-4cc1-947a-1ef80a5550e8
But I want to set them by using a list containing the "rName"s of those records, such as this:
mvFormA.rName=Jane, Bob, Dave
Is there a way to do this?
Smart fields operate on UUIDs (data saved is a reference to another record via UUID) and you need to set UUIDs
Is there a filter or something I can use to get just the UUID's that match my list of "rNames" from the example above?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When import or when you set teh values using rules? If the latter then you can use "Lookup and set" action instead and find the desired record via filter.. but you still need to set as UUID
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think that will work if I can filter by "rName" and then set the value using UUID's
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.