Skip to Main Content
Coming Soon: On April 2nd, all Suggestion Boxes will be migrating to The Network, Trimble's online user community. Your posts, votes, comments, and user accounts will transfer. This site will become read-only after the migration, and this banner will have a link to the new location for ProjectSight suggestions.
Created by Katy Rodina
Created on Jun 28, 2023

Programable Custom Fields / Ability to use Formulas in Custom Fields

Allow the custom fields to be created and use formulas and other fields existing in the records to calculate what populates in the custom field. For example, if we add a custom field in the line level detail of the CI for amount in foreign currency, I would want that to populate based on my currency type field indicating what currency the invoice is to be paid in and multiply it by the rate of exchange that is keyed into the portfolio settings. In PO if I create a custom field for total net difference on PO and want it to calculate the difference between the current PO value and the original PO value that i enter into a separate custom field, the net difference would be able to auto calc.

  • Attach files