Jump to content
  • 0

Conditional Formatting for List Box


jgavlak
 Share

Question

I created datapage web form and trying to perform conditional format on the data page.

I have a data table with a field called Attending(capture who attended a training session.) in my main data table.  I have a datapage user form for users (instructors) to fill out and submit training details, including names of who attended

Heres’ the issue I can’t figure out

  1. Need user to be able to select a location from the form dropdown and have another section open up with the personnel roster of the location they selected
  2. Personnel roster for each location is in a separate lookup table
  3. When they select the location and open the correct roster they can select individuals who attended from a list box and those selections get placed in the Attending field on the main data table listed above)

Is this possible with the software. I see only limited conditional fields in the documentation.

Thanks

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
14 hours ago, jgavlak said:

I created datapage web form and trying to perform conditional format on the data page.

I have a data table with a field called Attending(capture who attended a training session.) in my main data table.  I have a datapage user form for users (instructors) to fill out and submit training details, including names of who attended

Heres’ the issue I can’t figure out

  1. Need user to be able to select a location from the form dropdown and have another section open up with the personnel roster of the location they selected
  2. Personnel roster for each location is in a separate lookup table
  3. When they select the location and open the correct roster they can select individuals who attended from a list box and those selections get placed in the Attending field on the main data table listed above)

Is this possible with the software. I see only limited conditional fields in the documentation.

Thanks

 

You want ONE record for EACH attendant, correct?

If so, everything should be possible, the one with the listbox might be on the more complex side, though.

 

If you multiselect in a listbox, then each name will be separated by a comma (all in one field).

You can count the commas (plus one) so you'll get the total number of records selected, and then you can use maybe while loop until number of commas in Triggered Action, get first string up to the first comma, insert it to the table, update #inserted and remove the first name up to comma, and then it will repeat it until nothing is left and everything is inserted.

However, there might be a problem since this is a NAME, you have to make sure their names don't have commas so the Trigger will count correct

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...