Hi,
I am an business controller, not a programmer,- so forgive me this question - but I feel the use of idea will have more strength using dialogue boxes.
the video on dialogue boxes expects a general/ basic understanding of writing code.
What would be a good starting point to get this understanding?
thanks!
Lennart vanB
Offline
Last seen: 9 years 9 months ago
Joined: 07/14/2014 - 08:12
Hello Lennart and welcome to the site.
The code that is used in IDEAScript is Visual Basic for Applications which is the same macro language used for Excel, Word, etc.
I use a lot of dialog boxes in my scripts so you can look through the scripts and see what I have done. Also if I have an idea of what you might be looking for I could put together an example that you could use as a starting point.
Brian
Thanks Brian, I already feel welcome :)
VBA, ok. I tried to avoid that for a long time....
The idea is really simple. For my sales ledger lines I would like to have a dialogue asking for the month (numeric) and whether cumulative or per month. perhaps a dropbox with the month and a button to choose from "=" or "=<"
I'll dive into the code too.
Thanks and regards from Holland.
Lennart
Sorry, Lennart, if you want to learn IDEAScripting to its potential you are now going to have to dive into learning VBA, no choice there.
Let me know if you need any help creating the dialog or if you want to try something and post that would be great.
Thanks
Brian
Ok, I'll keep the site posted.
regards,
lennart
Hey Brian,
Is there a way that we can calculate the running total/ Cumulative total based on one amount column?
If not, Can we develop a macro to run the same?
Thanks,
Bibin
Hi Bibin,
I know there is a script like that already exists at IDEA but I can't seem to find it right now. It is not a hard script to create so when I have a few minutes I will put one together.
Brian
Thanks Brian.
I am waiting for it
HI Biban, I started it last night. I should have some time this weekend to complete it.
Thank you
Hi Bibin, try out this script.