I have two problems both of which are interlinked in a Travel Authorisation form that I am building.
I am attempting to hide a security warning message when a city field in a repeating section contains a security level and present the security message inside the Security Warning.
There is a list of Countries with columns for every city (used for cascading lookup below), where applicable each city has an associated Security Level assigned (calculated value circled in red below) and security comment (calculated value circled in Green below)
The requirements are to
a) Only show the Security Warning when a city contains a security level
- multiple cities are selected below and the security level is presented in an array y3,,1]
b) Present the Security Message as
KABUL - Please get approval from CFO
ORAN - Please get approval from the Budget Holder
instead of KABUL - Please get approval from CFO,#Value!,ORAN - Please get approval from the Budget Holder]
I would need to remove the blank values "#Value!," and remove the square blackets "k ]" and replace remaining commas with a line break if possible.
All calulkated fields will eventually be hidden using CSS,
I do believe this is possible using replace() but I have tried the inArray(0 with little success.
Appreciate any help here thanks
Chet