0
How would I code/formula for a MAC address in a text field?
If I enter the following: 00107FCFD06F
Is it possible to have it displayed like this: 00:10:7F:CF:D0:6F
places : and force uppercase
4 replies
-
In the "Trigger after update" of you MAC Address field enter this...
'MAC Address' := replacex(upper('MAC Address'), "(\w{2})(\w{2})(\w{2})(\w{2})(\w{2})(\w{2})", "$1:$2:$3:$4:$5:$6") -
Thank you so much! Only been doing Ninox for a day :-)
-
Worked a treat!!
-
Perfect! Thank you!
Content aside
- 1 yr agoLast active
- 4Replies
- 630Views
-
1
Following