I have need for several fields to be populated with a multiple choice options that are editable after being selected. The multiple choice text options are full paragraphs with lots of standard language, but just a few variables that will need to be added by the user after making the selection. I can't figure out the best way to accomplish this.
I would tackle this a little differently. Multiple choice fields are controlled by an application administrator. Standard Language for a contract, quote or what ever your business object is for the customer is likely from a VP of Sales, the Legal Department or some other Subject Matter Expert that is not a Quickbase developer.
Here is what I recommend for you to give the user and the SME control.
Having a Standard Language table can be exposed in another dashboard for the expert role that determines the business needs. You can let them control the Preview text as well as the full paragraph.
Your users will then select the Preview when they are building out data in the form. When they save the record, have that fire a Pipeline that gets the Body Text from the Standard Language table and write it to the Customer Field.
You can also have these be Rich Text fields. Hyperlinks, bold, colored fonts... all of that can be included.
When a change in the source data is needed, you will not get a phone call or email.
Yes i agree with Don. Better to have the options in a table which can be user maintained as opposed to a hard coded formula. The editable field can still be initially populated by a form rule.