So, for example, If I have a user select a value from a list lookup at the top of the form, is it then possible to use the value they choose as part of a label further down the form?
+9
Hi Mishaal
use a Calculated value control instead of a label control. There insert the lookup control name as formula.
Kind regards
Manfred
+4
Thank you Manfred
+9
Hi Mishaal
to eleminate prefix 'n:#' when using a list lookup control use formula
replace(Controlname, '^[^#]*#', '')
- ^ assert position at start of the string
- [^#]* match a single character not present in the list below
- Quantifier: * Between zero and unlimited times, as many times as possible, giving back as needed [greedy]
- # the literal character #
- # matches the character # literally
Kind regards
Manfred
+4
Perfect, thank you.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.