Hi Brian,
Can you maybe help me with this script? In order to prevent a script crashing because of varying field names, I would like to create a script that runs based on pre-identified field names that the user selects with dropdown listboxes. I managed to steal some from the scripts you placed on this site, but I'm stuck after the first listbox.
I want to create a summary that shows all the Journal entries in the "memo" journal. To do this, the user first has to select the field that contains the available journals and store this as a string called "Journals". When this has been selected, I would like the second listbox to contain the available journals in "Journals" and store the selected journal in a string called "memo". The third box should contain the entry numbers to summarize on (ans store it as string "Entry", but I guess the routine to fill this listbox would be the same as for listbox 1).
Then I would like the code to create a pivot table, with a pagefield set to filter on "memo", summarizing the accounts on "entry". Can you maybe whow me how to do this? If I get the general idea on how make the contents of listbox 2 depend on the selection in listbox 1, and use these selections throughout the script, this would be a huge help.
My "work in progress" script is added in the attachment.
Thanks a lot in advance!
Dennismes
Offline
Last seen: 5 years 4 months ago
Joined: 10/27/2014 - 09:20
Hi Dennismes,
I will put something together for you. It will probably take a few days as I am currently not at home.
Thanks
Brian
Thanks so much! Greatly appreciated.
Dennis
Hi Dennis,
Sorry for taking so long to get back to you. Here is an example script where you select the file, then you select the field and then you select a value from within that field. Hopefully this will help get you started. I have the script below plus I have attached it as a file.
Great! Thank you so much for your trouble! I'll get to work on it
Good luck with your project.
Hello Brian,
I've been consulting my Mastering IDEAScript book, which is woefully lacking in information about customized dialog boxes, and this thread seems to be the most appropriate for my needs. I have written a script that allows users to establish materiality thresholds for a variable they select. The script then exports those results to a new table. Right now I'm using two simple Input Boxes but I'd like to insert a more user-proof and nicer-looking Dialog with a Drop Down Combo Box and Edit Box instead.
My idea is that once the dialog launches, it will populate the drop down with only those table variables that are numeric so the users don't have to wade through a large list of selections. Then they can type the materiality threshold into an Edit Box. Attached is my current code, and a template of what I'm going for with the dialog. Any suggestions for adding in a custom dialog would be much appreciated.
Thank you,
Marie
Hi Marie,
It sounds like you are on the right track. For the drop-down I don't quite understand where the variables are coming from, are you talking about the numeric fields?
You might want to watch this video as it should help you out https://www.youtube.com/watch?v=KpaJCx72OO8
Yes, by variables I mean the numeric fields I'd like to have populated from the Journal Entry Detail table. Thank you for your suggestion - the video helped immensely.
well, I would like to know what could be causing me this syntax error, Thank you
A couple of things for you to check. The previous line looks like there is a quote at the beginning of it, that would make it a comment and cause an error but it should be in green, so I am not sure what is going on in that line.
In your menu do you have a Drop List Box with the ID DropListBox1?
The array listBox1$(), where is that defined? Is it defined as part of the Drop List Box or was it defined outside of the dialog?
Might be one of the above that is causing the error.
Pages