IDEAScript Questions

Hi Brian,
If my dialog have 6 droplistbox call DropListBox1 to DropListBox6, and those droplistbox all used same attached list array.
Have any possible, I add a button call "Auto Mapping", and pre-defind if DropListBox1 = SO_NUM, DropListBox2 = SO_LINE_NUM, DropListBox3 = SO_CUSTOMER, DropListBox4 = SO_ITEM, DropListBox5 = SO_UNIT_PRICE, DropListBox6 = SO_QTY, when I click the AuotMapping button the system can automated tagged as picture 2 ?
 
Regards,
Derek

Hello together,
I would like to know, if there is a possibility, to remove an actionfield from IDEA (v 8.0.5) with a script, similar easys as   field.SetActionfieldForExtraction ...

Hello
Is it possible to make a script that calculates the difference of days between 2 dates and add this difference in a new field ?
Example:
Sales              Payment      DATEDIF
05/05/2018 07/05/2018    2 
I know that on Excel the function is datedif (french translate function).
However, I do not find an equivalent function on IDEA 10.Thank you
 
 

Hello,I want to do a summarization with this script. I have a problem with the code, line 107 "Need to specify a field to summarize".
Someone can help me to resolve this script ?
Thank you
 

Hello
you know if there is any way to get a value from a field that is numeric, but it is very large and you have to bring it as long.
For Example exist types of Get Value

• ActiveRecord.GetCharValue
• ActiveRecord.GetNumValue

But ActiveRecord.GetLongValue don't exists
My Code:
MontosValor = RS.ActiveRecord.GetCharValue("MANUALESMONTO"))
Help, Thanks
 
 

Is there way to run an IDEAScript through define action field and specify parameters (using contents of field or user defined text) using IDEAScript?
Screenshot Attached to see what I mean
 
Scott
 

Hi all
 
I have built a script that extracts blank records from each field in a file. It is running without any error but it is not creating the extracted database.
The script is as below. Please help, thanks.
________________________________________________________________________________________
Sub Main
 
'Variable declarations
 
'Database objects needed from active DB
Dim NumFields        As Integer
Dim olddb    As Object
Dim task    As Object

I am new to scritpting and have been utilizing history to create most of my scripts. I wanted to try and script to create a pivot table but unfortunatly when you create a pivot table there is no history to review. Is there a snippet or could someone share an example of how to create a pivot table in ideascript?

Hi, I am back once again. Have been working on the script and its been smooth with serveral ups and downs.
The current issue I am facing is that I cannot seem to store information within an object and I have the same error coming back to me each time.
My Dialog box's name is NewDialogX
sFieldName = listBox1$(NewDialogX.DialogBoxDropListBox2)
 
Error : Invalid Qualifier
If I were to remove NewDialogX the code runs but no information will be store in sFieldName.
p.s I ran a message box right after this.
 
Cheers!

Hi Brain, 
 
How are you doing? can you help me with a bit of script? I'm trying to get browse window to select a file. I already found a bit of script that lets you select a folder, but i need to select the file. I'm having problems converting the script to let me select a file instead of a folder.
 
Function BrowseFolder() Dim oFolder, oFolderItem Dim oPath, oShell, strPath, item Dim msg As String