Select to view content in your preferred language

Need to add pages based on utility count

368
1
01-02-2025 12:39 PM
AirX
by
Occasional Contributor

1. How to change the separator from a comma to a forward slash when multiple values are pulled (See Material columns)

2. How can I add another page if needed to the exported report template if multiple utilities exist?

 

Right now we have it setup as separate templates for 1 utility, 2 utilities, 3 utilities Etc. and it would save us a lot of time and headache with one template.

0 Kudos
1 Reply
abureaux
MVP Frequent Contributor
  1. To replace text, there are really just two options. If this is text extracted from a repeat, then you can you the join() function. But that has limited applications. For more flexibility, and in your specific case (which I assume is a select_multiple), you will need JS (here is an example).
  2. You need to utilize repeats for that. Each utility should be a single repeat item. I.e., For each new utility, the user will add a new record to the repeat. Then, you can dynamically extend the report.
0 Kudos