You’re offline. This is a read only version of the page.
Announcements
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
Share
Report
6,048
All responses (
Answers (
