Ok, so basically I’m uploading a database of ski areas.
Each ski area has between 1 and 7 towns associated with it.
Right now in my excel each town is in a separate column
(see attached screenshot)
Am I right in thinking that it’s best to combine these into an Array to store this data?
Ie So I can code to display the array as a string of text on the Ski area dynamic page. Not have to link 1 text to 1 field for each one?
If so, does anyone have a Macro to combine these columns into JSON format?
Would it be like
That I’d then put in an array field?
Would this still let me put in a search function for towns on a repeater page?
Any help much appreciated.