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

Question

Question

Forms Cloud - Can you copy and paste list values into drop downs and auto suggestions?

asked on February 15, 2023

In Cloud it seems I can not copy my list values from the source to the drop downs and auto suggestions. Instead of a free entry field it looks like this and when I copy and paste it puts all values into the first choice

 

 

0 0

Answer

SELECTED ANSWER
replied on February 15, 2023

No, I don't think you can copy and paste the values into a list, although that would be a neat feature.  I remember that you could do this in the repository for a drop down list.

 

For Cloud, you cloud create a database, and a lookup rule and use the lookup rule to populate your radio button, check list or drop down list.  Then, to create or update your database you could copy and paste your list items into Excel (which should put each item into it's own row) and import that into the data manager.

This approach also has the benefit because the database and lookup rule can be re-used in other forms.

 

Hope this helps.

 

 

0 0
replied on February 15, 2023

Would that work for the auto suggestion too?

Previously we could just copy the data directly into the forms designer for all lists. Creating data sources seems like overkill just to create a list that is only used on one form.

0 0

Replies

replied on February 15, 2023

Yes, it works great for the auto-suggestion.  We used it for a several hundred long street name field.  Works perfectly.  

No doubt that it is overkill, and I am not suggesting that a copy and paste wouldn't be a good idea.  Just a workaround.

0 0
replied on February 15, 2023

Ok that works then, just new that we have to maintain the values in a CSV somewhere offline and update simple tables online instead of being able to just paste them into the field configuration like we used to for one time list items

The current interface is almost useless, I am never going to manually type values in, list values other than (Yes,No) almost always come from some source that they are copied from.

0 0
replied on February 15, 2023

Right.  Good for a short list of values, but for too many, the look up is better.

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

Sign in to reply to this post.