I have a table dimensioned by Position and Version. Our users would like the ability to add 100+ positions at a time, but the Bulk Add to List functionality only seems to be available in the actual List itself, and cannot be enabled for a table of metrics dimensioned by Position and Version.
The Position list needs to have auto-generated Unique IDs too, which prevents us from allowing users to upload a csv to create new positions.
Does anyone have any suggested workarounds for this? Thanks in advance!
Solved
What is the best way to add items to a list in bulk?
+10- Master Author
Best answer by Jack
Hello,
You should be able to do this as a two-step process, as it is expected that tables can’t receive bulk updates for the List items. You’ll need to:
- Create the Positions in the Position List first
- Then enter your data in the table.
For easier access, display the Position List as a widget on your Board alongside the table for folks to expand and bulk-create Positions there. For importing via CSV, there are some helpful replies that touch on the ID aspect here:
- Employee
- Answer
Hello,
You should be able to do this as a two-step process, as it is expected that tables can’t receive bulk updates for the List items. You’ll need to:
- Create the Positions in the Position List first
- Then enter your data in the table.
For easier access, display the Position List as a widget on your Board alongside the table for folks to expand and bulk-create Positions there. For importing via CSV, there are some helpful replies that touch on the ID aspect here:
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.