Forum Discussion
KirkTrachy1
5 years agoQuickbase Staff
Hi Frank:
Create a formula url field and insert something like the following:
This formula url field will create a button that will edit the record and take the value in the Text Field and insert it into fid_28 and then redirect to the same record in display mode.
The [Text Field] is the source text field and when the button is pressed this will insert that text into fid-28 which is your multiple choice drop down field. (NOTE: Be sure to allow the field to allow new additions. Edit the field properties and make sure the "Allow users to create new choices" checkbox is checked or you won't be able to add new values to that field.
Another option may be to use a Pipeline. Decide what your triggering event is and you could use that triggering event to fire a Pipeline that edits the record and take the value from the text field and insert it into the multiple choice drop down box. It really will depend on your triggering event.
We cover things like this in our daily, (M-F at 1pm Eastern) "Office Hours" webinars.
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
Create a formula url field and insert something like the following:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
"&_fid_28=" & [Text Field] &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() &
"?a=dr&rid=" & [Record ID#])
This formula url field will create a button that will edit the record and take the value in the Text Field and insert it into fid_28 and then redirect to the same record in display mode.
The [Text Field] is the source text field and when the button is pressed this will insert that text into fid-28 which is your multiple choice drop down field. (NOTE: Be sure to allow the field to allow new additions. Edit the field properties and make sure the "Allow users to create new choices" checkbox is checked or you won't be able to add new values to that field.
Another option may be to use a Pipeline. Decide what your triggering event is and you could use that triggering event to fire a Pipeline that edits the record and take the value from the text field and insert it into the multiple choice drop down box. It really will depend on your triggering event.
We cover things like this in our daily, (M-F at 1pm Eastern) "Office Hours" webinars.
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
- FrankCusack5 years agoQrew MemberThanks for this. I was also wondering, would it work too if I changed the option for input on the text box to input from list? and add the dropdown options to the original text box.
------------------------------
Frank Cusack
------------------------------- KirkTrachy15 years agoQuickbase Staff
Frank:
I'm not clear on what you are asking. Please be more explicit.
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
Related Content
- 6 months ago
- 4 months ago
- 11 months ago
- 5 months ago