Issues in using multiselect Field ?

Issues in using multiselect Field ?

Hi,

I'm currently evaluating Zoho Creator. I have an access app that I am are trying to replicate on Zoho. So far I have done with replicating one of our access form.

I have a MultiSelect text field in that form and I'm populating options in this field from 2 zoho database views/tables using deluge fetch function.

Problem here is, I want to show data from 3 different columns in single option. So I done that by appending data from columns into a single string. Check below,
  1. for each moveReq in move_quotes [Move_request_iD == a.Request_ID]

  2. {
          re_ID = movers [Mover_ID == moveReq.Mover_ID];
          Allocated_Movers:ui.add(moveReq.Mover_ID + " | " + re_ID.Mover_name + " | " + re_ID.Comments);


  3. }

It works fine though. But issue is, when user selects any option it returns me the whole string. Lets say "1 | XYZ | Test Comment" and I have to parse the string and fetch out the movers number that I actually need.
  1. ID = multiSelectField.getPrefix(" |")).toLong(); //thats how i'm doing right now

So I would like to ask, isn't it possible to have a HTML like field? For instance:

  1. <input type="text" value="1 | XYZ | Test Comment" name="myMoverIdField">

we have separate value and a name/variable to fetch the value..?

Looking forward for quick response.

Intesar.