Alan Cooke
-
Subtracting 8 hours from a time worked field.
I have a formula field given the result of Date/Time Start and Date/Time end which works fine. For example such a result would be 9:00 (1 hour overtime given the day is 8 working hours).…
-
I would like to copy the contents of a field to the same field in the next record
Adding device details such as serial numbers. These could be all for one project in "Project Title". To save myself and user having to select the project tile repeatdy how would I creat a formula to…
-
How would I code/formula for a MAC address in a text field?
If I enter the following: 00107FCFD06FIs it possible to have it displayed like this: 00:10:7F:CF:D0:6F places : and force uppercase
-
MAC Address mask for input of text field
In my field of work, Audio Visual, we record MAC addresses. It would be very nice if one of the format options for a text field was for a MAC address. Typically: 00:10:7F:CF:D0:6F.…