Search the Community

In a previous post in this forum I was hoping to use List-Type-String fields so the user can select multiple choices, but I can't use display/value (just one value). So instead I'll use a traditional Text255 field (TextField1) set to List field element on a datapage, with javascript so the user can multi-select records. This is saved as a comma delimited string where each record the user saves is an integer value (they see a text display value but the list box saves the integer as the record). This is the js to multi-select: <SCRIPT LANGUAGE="JavaScript"> /* "fieldName" is the variable name for the listbox type form element field. */ var fieldName = "EditRecordColumn_Hide"; var x=document.getElementsByName(fieldName); x[0].multiple=true; </SCRIPT> Then I have a string with a set of numbers going from 20 to 1, in z/a sequential order, comma delimited. This string could be in table field or a virtual field (or just in a javascript line)--not sure the best approach. So this string would be 20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1 What I need to do is, in another text field (TextField2), remove the integer values (and their following comma) from the 20-1 string, so all that's left are integers the user has NOT selected in the list box. For example, if the user selects 5 records in the TextField1 listbox with a saved string value 18,12,9,6,2 I would need the result in TextField2 to be 19,17,16,15,14,13,11,10,8,7,5,4,3,1 This can happen either as TextField1 changes with each selection the user makes, or after they mouse out, or before Update (this is on a Single Record Update datapage). This way I'll have just a string of integers (comma delimited) that the user did NOT select, in TextField2. Any help on this would be really appreciated. I'm using the final TextField2 string value to be passed as a parameter to another datapage (tabular) where js in the Search Footer uses the integers to remove columns in the results. The selections the user makes in TextField1 are header labels (and placement numbers) for columns in the tabular report. This enables the user to select which columns they want to see, making it a user-customizable report.

Hello, I have a multi-select listbox on a datapage called "TeachingArtists" where a user can select one or more artists and assign them to an educational program that is taught in schools. On a separate data page, I have the user selecting the program name and have a cascading listbox that filters on program name so user sees only the artists linked to the program name. The problem I am running into is that the some of the entries in the listbox contain multiple values of artists names separated by commas where ideally I want each artist name listed separately. Is there a way that I can parse the comma delimited artist name values and present them as single entries in the listbox? I am attaching a screen shot for reference. Thank you for your help.

I also posted this in User JavaScript and CSS Discussions because I'm not sure whether custom script was required to achieve this result. I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.

I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.