Remove field from multiple reports
Ok, when I created my application, I set up a formula text field [Service Order # (Automatically Generated)] to automatically generate a service order number. However, we were notified by our client ...
Forum Discussion
There are different ways to approach this but my recommendation is going to be based on the Usage of the current formula field. You can either:
1. Use the new entry field as the data-entry field value and still use the formula to display either/or. This means you have 2 fields; which is not as clean for your system.
2. Depending on your Usage of the formula (which probably has a high-usage rate across forms, reports, lookups, email notifications etc.); you may be smarter to temporarily populate the formula values into the new Service Order # field; and then change your formula to a regular entry-field. Then update your old-formula (now data entry) and populate it with all the values stored in the Service Order # field. Then you maintain only 1 field for data entry/creation; you do not need to update any looukps etc. unless you are changing from a numeric to text or vice-versa and you keep the table clean with only 1 field value representing the order #.
1. Use the new entry field as the data-entry field value and still use the formula to display either/or. This means you have 2 fields; which is not as clean for your system.
2. Depending on your Usage of the formula (which probably has a high-usage rate across forms, reports, lookups, email notifications etc.); you may be smarter to temporarily populate the formula values into the new Service Order # field; and then change your formula to a regular entry-field. Then update your old-formula (now data entry) and populate it with all the values stored in the Service Order # field. Then you maintain only 1 field for data entry/creation; you do not need to update any looukps etc. unless you are changing from a numeric to text or vice-versa and you keep the table clean with only 1 field value representing the order #.