Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

• Home /
• PF-I-250 /
• New Suggestion

19 Vote

"Reset" to un-create a UD Table

Many times after designing a table, I've discovered I need to change something about the key fields, but have to delete the table and start from scratch again (usually with a screenshot to help).

I'd love to see the ability to "RESET" a table. This would:

1. Warn the user this will delete all records
2. (Delete the records)
3. (Delete the form, table, and views that were generated)
4. Re-enable editing to the same level it was when initially adding the table columns.

Then I could make my changes to the key fields and hit 'Update Table' to again create the table. 

This would allow much quicker work during the design phase of custom tables. Even though I design everything on paper first, sometimes something slips up like a datatype or field length mismatch or something.

Perhaps if the 'Form Name' is left the same, even FORM SECURITY could be re-applied?

• Nathan Sutherland
• Dec 28 2016
• In Review

UD - User Database

Company	Cutting Edge Plumbing & Mechanical
Job Title / Role	Developer
I need it...	3 months

• Comments (3)
• Votes (19)

• Attach files

  Enter a subject
• 
  Greg Saunders commented

  August 30, 2022 12:54

  I have ran into this same situation as well. It can become cumbersome if you miss a mistake. I personally have fixed behind the scenes in the underlying Vista tables, but that can be risky. I have only done it, because I have become very familiar with those tables and had some very large UD tables I didn't want to rebuild completely from scratch.

  ×

  Attachments Open full size
• 
  Nathan Sutherland commented

  February 05, 2021 20:13

  Just ran into the need for this again today. Any chance someone in VP has dropped it in the "to be developed" list yet?

  ×

  Attachments Open full size
• 
  Nathan Sutherland commented

  August 08, 2019 22:38

  Glad it's being reviewed! Fingers crossed!

  ×

  Attachments Open full size

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Log in / Sign up

Identify yourself with your email address

Email address

Subscribe

You won't be notified about changes to this idea.

Related Suggestion

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.