Changing field format
Hi, is it possible to change the type of a filed in a database? For instance, I have a database in which I would change a free text field into a choice type field, in order to force, from now on, selection of values from a list (I don't need to modify preexisting values). Thank you very much for any help. Enzo
1 reply
-
sadly there isn't an easy way to convert field types. you will have to create a new field then create a button that will copy the data from the old text field to the new choice field. something like:
for loop1 in select Table1 do <--replace Table1 with the name of your table. add where statements if you want to only do a subset
loop1.(newChoice := oldfield) <--replace the newChoice and oldfield with the appropriate names of your fields.
endThen you can just delete the oldfield and continue to use the newChoice moving forward.
Content aside
- 3 yrs agoLast active
- 1Replies
- 304Views