Re: Adding a required field to Contacts when already populated

methodcrm@seniorlifeconsulting.com — Fri, 23 Sep 2016 22:45:17 GMT

Thanks for such a quick response, Ben, and I appreciate your offer to help work on this together! This is a perfect and understandable solution.

My preference would always be to build constraints into the database, but the ability to build them into the UI through validation shows the thought that went into the product.

I have only worked with method:crm for a total of a few hours, and clearly there are a ton of capabilities I will discover as the needs arise. Kudos on the flexibility and configurability!

Thanks again,

Larry

Adding a required field to Contacts when already populated

methodcrm@seniorlifeconsulting.com — Fri, 23 Sep 2016 17:23:43 GMT

I need to add a new required field to Contacts, and the table is already populated with contacts. However, the "New Field" page says: "Unique and/or Required are disabled because the Table already has records. To add a field with Required or Unique settings selected, please clear all records first."

Obviously, I do not want to "clear all records," so what is my alternative? Is there even a "clear all records" option? If so, can I reliably export Contacts, clear the table, add the new required field, update the export to include values for the new field, and then import the contacts back in, keeping all data, relationships, dependencies, links, etc., intact?

Search results by user ID 7267

Re: Adding a required field to Contacts when already populated

Adding a required field to Contacts when already populated