Can anyone tell me how can I insert a column automatically?
I’m betting that what you’re trying to create is a new column for an additional entry of some type, yes?
- For example:
- Say I’ve got a column that records the total number for the “first” item
- Then I’ve got another column for the second…
- And a third, fourth, etc…
- One column for each entry
And the problem you’re facing now is that when someone wants to add a new entry into the mix, you’ve got to add a new column into the table… yes?
If you’re finding that you’re needing to add “more sections” into a table… that’s when it’s time to split that table into a parent-child combination using a reference.
Here’s a video I made a while back discussing this topic:
1 Like