How to use array parameters in Excel Online Forms using Office Scripts!!

Описание к видео How to use array parameters in Excel Online Forms using Office Scripts!!

In this demo i have a table of students at a school. I am recording their name, age, gender, school year and their extra curricular activities. All of those fields are declared either as a string or number type. One final field is the Grade Average field. This is declared as an array type and the user can enter an array of grades. The script calculates the average of those inputted values. Any amount of values can be entered. The average will always calculate.
If you are wondering, yes, the form can handle 2 dimensional arrays! Though, whether your human data inputter can is another matter!
Thanks for watching.
GitHub resource: https://github.com/MrAnalyticals/Offi...

Комментарии

Информация по комментариям в разработке

Похожие видео