I have created pivot table based on your video,my combox is month, horizontal gallery is wéek number and vertical gallery is person name are done but sum of hours data not showing, can you aasit me
How can I patch the rows to a collection? I have the information in input textboxes because I want people to be able to edit the numbers, but I'm having trouble saving the numbers to a collection.
you can use collect function to patch (add rows) to an existing collection You can use patch function to patch a value to an existing row in the collection. Patch(name of the collection, record to be updated, {column1: value 1,column2:value2.....}). To provide exact function Would need more details
Yes we can add sub items. Instead of grouping by one field, we would group by two or three fields. Formula for all the values would have two or three additional conditions in the filter function based on the fields we are grouping on
You would need to use delegable operators in your functions. Plus you would need to make sure none of the functions return more than max 2000 rows. Would need to see the exact function to provide an exact answer