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
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
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
Excellent one. Enlighten us more with your knowledge
Very nice share 🎉
Great video, thank you for sharing 👍
Thanks for watching!
Excellent.
Thank you! Cheers!
Perfect. You save me!
Glad I could help!
You’re a life saver. 🤝
10:42, how can you copy and paste several lines at the same time.
Great video. This is so useful. Can you also explain how to show dates as rows and Patch to edit the Values, please?
Thank you! Sure will try to upload it as soon as possible.
Sir i made it in similar way but m not able to sort the gallery based on grand total
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
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
I would need much more info for that. The structure of you SharePoint table including data types and exact functions you are using.
Can you add sub items.
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
How do I Remove the Delegation issues….? can Anyone Help me in that
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
good luck with that