Today's video will address changing values within a normal multiple choice field in a Knack database app. You need to be careful when doing this, as if you change an existing choice value, any records with the old value will remain having the old value. I'll take you through the process to do this correctly. Please check it out. Thanks.
Interested in my Knack database services? ... Book a call with me here: https://calendly.com/daveparrish/callwithdave
Full Transcript
0:00 Hey folks, Dave Parish here coming at you with another video. Umm, this would be fairly short. Today's topic is changing a multiple choice value. 0:14 And there's something to watch out for.
0:00 Okay folks, here is the load-own uh changing multiple uh choice values and uh, uh, but to watch out for. Here's a simple app I have multiple choice right here. 0:16 It's an app, one of the next template things about uh, apartment unit's ability but we have a multiple choice here, stats. 0:24 I look at being renovated, ready to rent, rent it. And notice this, I spelled renovated wrong. Thank you. I did that intentionally. 0:34 So if we look at our records, here we go. We just have three of them. And this comes in the play we don't talk about when you have a bunch of records. 0:44 Uh, and there's one with the wrong spelling. Well, better make that right. Now people would do this because they have a misspelling or maybe the word it's wrong is that they think well I can go change it. 0:59 I see this all the time. So let's make this right. Okay, that seems cool. We're gonna save it and go back to the records and the one that was spelled wrong is still spelled wrong. Some people think when you change this it's going to carry over to all the other ones that is not like that. 1:21 All that is doing is inserting text in here and if it's wrong it's going to remain wrong you're gonna have a problem with all those other records. 1:32 Again, this will come to the play when you have lots of records. Now here's what you do about it. If you find spelling and you don't have a bunch of records and they're wrong. 1:40 Here's how you would do that. I'm gonna go back here and I'll make this wrong. Okay. What you do? Did you leave that value there? 1:54 You put it in the correct one. You like the spelling correct? Right here. So now we have the wrong one and the right one. 2:05 Here's how you manage that. You can go to records. And you're gonna do an update. And what we're gonna do is we're gonna look for status is the wrong one. 2:20 Next and we're gonna change that the value to the right one, do next, update it. Now again lots of records it's gonna go take care of all of them. 2:34 It just took care of this one. So then you're gonna go back to your selections. You no longer need the wrong one. 2:40 Because you've covered it and say that that's how you manage when you change the value of a multiple choice when you have existing records. 2:50 Now another way to do this is actually be another video topic. Is to have a related table. Thank you. Of values and instead of choosing a simple multiple choice field, it's going to be connected to a table that has those choices on it. 3:05 When you do that, I'll go to this in detail. But that's uh when you do that you're going to have a change. 3:12 And value is going to carry over to everyone. And also with a related table you can have other variable information that makes managing and having that multiple choice more robust. 3:23 For example, let's say you have a year associated with 22, 23, 24 and people are selecting from it. Umm. What you can do there is have another variable which is active inactive and as years go past you can inactivate the old ones that you don't want them to select for or even ones that are further out 3:46 . You only want them to select from a small range. Uh, set it to inactive and then put a filter on a selection that only show active ones. 3:55 You might even built a panel that with some time value and a conditional rule and have a j would automatically. 4:01 But that's what I got today. I it. Take care. Thank for watching.