IDEAScript Questions
Fill Down Macro within an IDEAScript
Forums
Hi all - as always, thanks in advance for the help!
I use the Filldown Utility from the IDEAScripts section of the site all the time. What I'd like to do is incorporate that functionality into another script I've built that does some file cleanup on a standard file I receive frequently. But, I want to skip the dialogue box to select the fields to fill down and instead have a defined list of ~5 fields to run. How would I do that?
- Read more about Fill Down Macro within an IDEAScript
- 5 comments
- Log in or register to post comments
Scripting for a field selected by the user in a dialogue box
Forums
Can Anyone PLEASE help me !
I am attempting to make a dialogue box where:1) The user selects a database2) Selects upto 15-20 feilds from a drop down which are mapped in my report.3) The fields the user selects are then renamed(modified) to a particular name.4) I have a generlaised script that will then, run for further analysis basis those new fields names. The problem i am facing is - How do i script the following:
Collect All Files ideascripts in a project
Forums
Hi there.
I have may Idea files (*.IDM) in a project. Is there a way to collect every single ideascript for those idea files?
Thanks in advance.
- Read more about Collect All Files ideascripts in a project
- 4 comments
- Log in or register to post comments
Multi msgbox displayed
Forums
Hi all,
I am writing my first IDEA script. I have searched many topics but could not find the solutions. My problem is msgbox displayed many times when users click on the button several times. In the pictures attached, when users click on Check Ready button 2 times, 2 msgbox will be displayed. Hope to hear from you soon!
- Read more about Multi msgbox displayed
- 4 comments
- Log in or register to post comments
Create new field and populate it with data from equation
Forums
Hi,
I'm having a bit o a trouble with a script. I want to builda script that creates a new field and insert data in it based on the data existing in one field.
I have uploaded the script.
Basicaly, I want to create a field called CUI and populate it with data from the field FIRMA using the equation @JustNumbersTrailing(FIRMA) but I keep getting the error "Error on line 18 - Automation object does not have a deault value".
I would appreciate some suggestions.
Date Input
Forums
Hello, im trying to create a script that has an input option to select a time frame on a dialog. For example i would like to be able the user to input a date (12/31/18) and then pull all transactions for the 12 month period ending 12/31/18. Or enter 9/30/17 and then the script would run for the previous 12 months.
Thanks in advance for any help.
- Read more about Date Input
- 2 comments
- Log in or register to post comments
Boolean and check box
Forums
I want to use a check box so that the user can decide of select a option or not. Now when the user starts the second part of the script the result of the menu is send back to the boolean (BenfordsA = MainMenu.BenfordsA). The problem is have is that i want to set the default value of the check box on (true). When i set MainMenu.BenfordsA=True before the select case it wont be changed when the user starts the second part of the script with this code BenfordsA = MainMenu.BenfordsA.
- Read more about Boolean and check box
- 1 comment
- Log in or register to post comments
Unique ID for character fields
Forums
Is there a way to create a unique numeric field for several character fields? The reason is the benfords law analysis which tends to mark records as suspicious based on different criteria (first two digits, last two digits, second order and summation). For the user i want to combine the suspicious results but i want to eleminate double results.
- Read more about Unique ID for character fields
- 1 comment
- Log in or register to post comments
Fixing Date formatting
Forums
I am building quite the long script but I will outline the current issue I am having and paste in the relevant code sections:
I am appending a file with the age of individuals as of the year end. The year end date is input by the user into a dialog box, once ok is selected, I want a number of functions to run based on various inputs into the dialog box.
I am getting an error saying -Paremeter not date. I have a number of fields that are dictated by this date, so I am hoping one fix will remove errors in all of the functions.
- Read more about Fixing Date formatting
- 3 comments
- Log in or register to post comments
selectionner element dans une liste
Forums
Bonjour,
J'ai développé une application qui utilise des listbox dans une interface graphique. Je n'ai pas de difficulté pour afficher ces listes, ni pour récupèrer l'indice de l'élément sélectionné par l'utilisateur.
Je souhaiterai pouvoir selectionner par macro l'un des éléments de la liste (exemple : sélectionner le quatrième élément de la liste), je n'ai pas trouvé une fontion de type "maliste.SelectItem(4,true).
Existe t'il une fonction qui répond à mon besoin ?
Merci d'avance.
- Read more about selectionner element dans une liste
- 4 comments
- Log in or register to post comments