We are using a multi choice field which contain values that we don’t want users to select moving forward. However, we need the values that were selected in the past to remain as they are when viewed. How do I do this?
Hey @Paul2, instead of a multi choice field, you can replace it with a connection field to another table of options, which will include a status field of ‘active’ and ‘inactive’.
You can then add a filter on forms for that field that only shows options that have a status of ‘active’.
This means you’ll be able to maintain old options and restrict users to only select new options.
1 Like
Thanks, Stephen, for your amazingly fast response! I tried to do this when I built the app, three tears ago, but couldn’t figure out how to link the data in the table to a selection control. Can you point me in the direction of an example I could look at?
Paulmy iPad
All good! I just made a video for you to demonstrate this:
Hope that helps!
Thanks Stephen, this is perfect.
Paul
1 Like
Hi @Paul2 - I appreciate my good friend and colleague @StephenChapman has already answered your question. I’m just catching up on the forum as I’ve been on vacation.
Although this is covering the same ground I thought you might find it of use. I recorded it a couple of years ago but it’s still relevant 
1 Like
Thanks For this Carl. The video is a good resource for this issue. My next dilemma is migrating from the data from the choice field to a connected table. If I was loading the data from scratch I would simply use a connection on import, but since the data on the primary record is already there, I’m assuming I would have to export, delete and re-import the data.
Here is the current structure:
Profile - describes a person
Lineage - many lineages to a person
Step - many steps to a lineage
The step has a “type” multi-choice value which I would like to migrate to a connected table with a one-to-one relationship. The question is how to migrate the data without exporting and re-importing the current Step data. Is there an easy/safer way to do this?
Paul
@Paul2, I believe the only way would be to export and reimport unfortunately.
In most cases you could use Tasks to update fields based on other fields, but updating connection fields based on other field types does not work.
I feared as much. Thanks for confirming my suspicions, and responding so quickly.
1 Like
Sorry for the delay, the time zone difference beat me as I was asleep. I’m glad the video helped. Agreed with @StephenChapman on this one.