I'm wanting to have a predefined list of values for an input box coming from 2 fields, [Name] and [Name2], I currently have just [Name] in using the formula
=concat([Name],',')
Does anyone know how to do this for two fields at once so both sets of Names are in the dropdown?
Without testing and they may not fit your situation but try:
1. Create a combined field in the load script using the '&' '&' method to join (don't think that's what you're after)
2. Try, =concat([Name],',')&', '&concat([Name2],',') - you can be quite flexible with the concat statement; I find the best way to ensure it's returning the correct results is to enter it into a text box first to make the results clear. Add a 'distinct' statement in to the concat() expression if you need to de-duplicate the list.
