Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
5 years ago

how to edit multiple choice text

Hi All, Can you please let me know if we can edit the text of "multiple choice text" Consider I have a column Department which is a multiple choice text Initially , I had three choices , Mat...
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
After adding the new choice and removing the old one, You will need to run a list all type report on the Parent table and then use the more button to Search and Replace in that field to change Bio to Biology.

Then do the same on all child tables

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
5 years ago
Hi  Mark,

Thanks a lot. I will try and get back to you in case of any issues.

Note: Got a suggestion from a friend to download the data with the record id in a csv and then edit and upload it back. There by, we will not change the child table.

Thanks

------------------------------
Pushpakumar Gnanadurai
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    In the child table, is this field just a lookup field or is it the reference field in the relationship?  I assumed that  that it was the reference  field in the relationship.

    if it's a lookup field it will update automatically.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew Assistant Captain
      5 years ago
      Yes, it is just a lookup field.

      Thanks

      ------------------------------
      Pushpakumar Gnanadurai
      ------------------------------