bulk option Import in Single & Multiselect field
S
Satyam Chaturvedi
Adding options one by one in single and multi-select fields is becoming very tiresome and time-consuming. It should be addressed by implementing a function in the software that allows adding multiple options simultaneously, thereby enabling the addition of several options in these fields at once.
Jon Darbyshire
Hello Satyam Chaturvedi! I have a few more questions for you:
- Could you provide more details on how you envision the bulk import feature for single and multi-select fields?
- What is the average number of options you usually need to add to these fields?
- Do you have a preferred format for importing these options (e.g., CSV, Excel, etc.)?
S
Satyam Chaturvedi
Hi Jon Darbyshire
- I am using SmartSuite as a database where many people input data through forms, and this data gets updated in SmartSuite via Make.com integration. To display SmartSuite data through sSoftr oftware and ensure everyone uses it correctly, filtering is necessary, for which single or multi-select fields are being used.
- It may require around 500 or more options, and as we work in a larger field, we'll need to provide even more options.
- The most convenient way to create options is through copy-pasting, which can also be done in CSV or Excel. I use Joho Forms software to collect data at the field level, where you can copy-paste to create options. It also has the feature of a global list, so we don't have to create different options for each form; we just need to select them.
Sharing this as a reference - https://help.zoho.com/portal/en/kb/forms/adminguide/articles/global-choice-list#Creating_a_Global_Choice_List