Above is my table, All choice column have values like. There are 6 companies, 12 month, 3 Office Locations, 7 Categories.
On one click i want to make a collection where schema is a value for every combination and permutation of this choices.
For eg.
Year | Company | Month | OfficeLocation | Category | Rate | Amount |
2021 | Company A | January | Ahd-A | AdminExp | 74 | 0 |
2021 | Company A | January | Ahd-A | Rent | 74 | 0 |
Same for all the companies * all the months * all the office location * all the categories. Just rate amount and year will be fixed. i Can do that for one choice field as you can see from below pics.
I don't know how to do that for combinations. Let's say if i try below code it will create 84 entries for 7 companies and 12 months. But even in the company field it enters Months. Because inner for loop is for month. What i want is each company has 12 entries for 12 months.
Any help please.
Ok. This did the trick. Should have known it will be something simple