topic Re: recurring program , can i make a function ? in App Development

recurring program , can i make a function ?

Broly21000 — Mon, 05 Sep 2022 14:40:40 GMT

Hello evryone ,

I have a sheet that makes a program that I use often, is it possible to make it a function with parameters in which I could call in all applications?
For example a function that allows me to do a load to generate all the orders of a customer for a specific category.

can I make a getOrder function with customer id and category id as parameters

and that I can call this function everywhere ?

Re: recurring program , can i make a function ?

Aurelien_Martinez — Mon, 05 Sep 2022 14:59:06 GMT

Hi,

You can create function with the key word sub. Example :

Sub getOrder(customer_id, category_id)

//script

end sub

Call getOrder('1323', 'AAE33');

Re: recurring program , can i make a function ?

Broly21000 — Mon, 05 Sep 2022 15:16:54 GMT

thank you for your comment, how to call this function from another application without rewriting it?

Re: recurring program , can i make a function ?

Aurelien_Martinez — Mon, 05 Sep 2022 15:26:28 GMT

You can write your function in text file and load it with the include
instruction.