I have a checkbox in a table to deliniate a category: checked or not checked. If not checked, the record is an asset without a serial number. When not checked, I need TrackVia to copy the auto-generated numeric field (unique ID) for that record to a text field as a substitute for the serial number.
PWB shared this idea · Nov 3, 2014
Comments
1 comment
Hello,
This is a common enhancement request that our product team is working to make available in TrackVia., Unfortunately it's not currently possible to use check boxes in a function, but it is possible to use drop down list as an alternative in a calculated text. The drop down would have only one option- "Yes" otherwise the drop down would be left blank. We'd then create the formula to output the serial number if "Yes" was selected and the record ID if it was left blank:
if({Drop Down field}="Yes", {Serial Number field}, {Record ID field})
This function will output the serial number when the drop down field is equal to "yes" and will output the record ID when no option is selected.
Regards,
Alex
Please sign in to leave a comment.