• EH Lim

Insert the Comment field of a Validation list into the form

Set up the transaction field with a Validation list helps to keep the field as a mandatory and maintain consistency in data entry.

The validation code, which recorded in the transaction field, will be printed when the transaction field is being added to the form.

However, If you prefer to print the Comment of the validation field instead of the validation code, which has been recorded in the transaction, then a Find ( ) function is needed.

For example, if the "ShipVia" validation list is being tagged in the Transaction.User3 field, to print the comment of the "ShipVia" validation list you need to insert a Find ( ) function into the Invoice template.

Find ("Lists.comment", "ListID = `ShipVia` and item = `"+user3+"`")

The above Find ( ) function will search for the comment of the "ShipVia" validation list, which has been recorded in the transaction.user3 field, and print it onto the form.

Example of a ShipVia validation list:

Validation Code Validation Comment

SeaFre Sea Freight

AirFre Air Freight

If "SeaFre" validation code is recorded in the invoice transaction, with the above Find ( ) function, the Validation Comment "Sea Freight" will be printed on the invoice.

#template #MoneyWorks #Singapore #accountingsoftwaresingapore



33 Ubi Avenue 3 #07-50 VERTEX (Tower A) Singapore 408868 


T: +65 6634 6065

F: +65 6337 2616

  • facebook

© 2013 by

LedgerWorks Pte Ltd

Proudly made by Wix.com