You are viewing limited content. For full access, please sign in.

Question

Question

Is there any way to change the type of a field in forms?

Forms Version 10
Updated January 12, 2017
asked on January 11, 2017

I have a client who's form has 100 fields that are radio button's with 3 different options.  They asked if instead of the radio buttons we could do a drop down for each of those fields.  I was hoping to not have to delete and recreate each of those 100 fields but that is the only way to do from my experience.  Does any one else know different?  Can you change a field type in forms?  If not will this be something that we'll be able to do in the future?

1 0

Answer

SELECTED ANSWER
replied on January 11, 2017

If you want to change the all the radio buttons to dropdown for a specific form, you can find the form id from the URL when edit the form and then run following queries to update them after replace the {formid} with the id of your form:


 update [dbo].[cf_bp_dataset] set [attribute_type]='select' where [attribute_id] in (select [attribute_id] from  [dbo].[cf_fields] where form_id={formid} and [type]='radio')

  update [dbo].[cf_fields] set [type]='select', size=50, cols=NULL, other_choice=NULL where form_id={formid} and [type]='radio'

 

6 0
replied on January 12, 2017

That worked, thank you!

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...