I have a list, where I want to have a lot of columns with different name but identical type. The type shall be "choice" whith some predefined choices.
Edit: detailed explanation of my goal: I need to document the access rights on a sight collection, as there are several people in charge of administrative tasks which have to align their actions. So I'm building a single custom table with users/groups corresponding to rows and subsites as columns. There are additional columns holding the names and other descriptive datas on users and groups, but they need to be updated once, so they aren't in the focus now.
To document the access rights of a specific group on a certain subsite I made a column with the name of the specific subsite which provides a choice for each field allowing to select from the well known and some intermediate privilege levels. Everytime I generate a new subsite which breaks inheritance, the access rights shall be defined/documented here, by adding a new column of this type. Then I have to define this column for this subsite from scratch. This means:
- add column
- change column type to choice
- add a description
- add all choices
- define the standard value
So this can be a lot of work if done manually for every column. And it's error prone, too. So I thought about having a template for these columns.
defining a site column and rename it when using it multiple times
open the list in Access and make copies of columns
trying to make copies of columns in QuickEdit
while 3 simply doesn't offer any opportunity to do what I want, I probably wasn't good enough to find the right ropes in Access for option 2. Option 1 seemed to work until I wanted to insert a second column. Then I had to realise that my site column apparently had been "consumed" by my first column in the list despite having it renamed.
So is there any easy way to produce identical columns?