I received some awesome information from Tom Whitfield today and thought I would share.
This article is specific to his use case but will work for any field modification or correction outside of the Form Designer interface.
NOTE: Working directly with the JSON file is potentially destructive and could cause you to lose access to all of the fields and thus the data in your workspace. Neither I, nor RightStar Systems is responsible for any data loss that you may encounter by following this guide. Use at your own risk.
How to change the number of decimal places on an existing real number field in Footprints:
- Open the workspace form in Form Designer. Save the form as Draft. DO NOT PUBLISH THE FORM!
- Go to C:FootPrintsServiceCoredbMASTERxMRFBDesignData.json
- Make a backup of this file.
- Open this file with Notepad.
- Copy the entire contents of this file.
- Go to http://jsoneditoronline.org
- Clear out the “Hello World” app on the left hand pane.
- Paste the contents of the .json file onto the left hand side.
Click the right arrow:
- Go to the Fields object. Expand it out.
- Find the field name you want to modify and expand it.
- Find the Length attribute and modify it.
- You will see two items: scale and precision. Scale is the number of places after the decimal.
- Change the scale to whatever value you wish.
- Click the Left arrow. This will expand the file info in the left hand pane.
Click the Collapse button:
- Copy the text in the left pane.
- Go back to Footprints and close out of form designer by closing the browser window or clicking on Home. DO NOT PUBLISH THE FORM!
- Replace the contents of the FBDesignData.json file with the information pasted from the JSON editor.
- Save the file.
Go to SQL and run the following query, where ‘x’ is the workspace number in Footprints :
where WsID =
- Open Form Designer in Footprints.
- The new decimal point value is now displayed for the field.
Thank you, Tom, for this very helpful information.
by Evans Martin, RightStar Systems