IDEAScript Questions
How to Get Next Record Value by IDEA Script?
Forums
I try to add a Line-Item field with below script, but the GetNextValue can not be accepted in IDEA script, does anyone know how to get the next record value by IDEA script?
Doc
A001
A001
A001
B001
B001
-------------------------------------------------------------------
Doc Line-Item
A001 1
A001 2
- Read more about How to Get Next Record Value by IDEA Script?
- 6 comments
- Log in or register to post comments
Creating a script to take the medain of a row across multiple columns?
Forums
Hello -
I am new to IDEA, and was hoping someone could assist me. I have files in a similar format as below. What I need to do is take the median of Amt1 - Amt5 for each value in the Text column. I created the median field using the excel function and was hoping I would be able to do the same in IDEA.
I've been able to compute the median for individual columns, but have not yet figured out a way to do it across a row.
Thank you in advance.
Suppressing error messages
Forums
Hi Brian,
I am implementing CaseWare Monitor and that will be used to run my scripts and manage the subsequent exceptions. To do this, I can't have any message boxes pop up through the script, including error messages, as CaseWare Monitor will just hang waiting for the user to press OK.
- Read more about Suppressing error messages
- 8 comments
- Log in or register to post comments
Sample script to run a macro...
Forums
Does anybody have an IDEAscript to run a macro?
- Read more about Sample script to run a macro...
- 13 comments
- Log in or register to post comments
Running the Same Command on Multiple Tables
Forums
Hello-
- Read more about Running the Same Command on Multiple Tables
- 9 comments
- Log in or register to post comments
Open Documents - Hyperlink
Forums
I have a long list on transactions and a pdf copy of an invoice for each on my computer.
Is there way for me to define an action field such that I can click on the document number field in IDEA, and automatically open the correct document on my computer?
The helpdesk said it is possible using a script, but I haven't had much luck.
Thanks,
Will
- Read more about Open Documents - Hyperlink
- 4 comments
- Log in or register to post comments
Editable Fields
Forums
Hello,
Can we have a way to add variables to editable fields?
I have a database with a editable numeric field and i want to add to a certain field my record counts from other databases.
My idea is the version 9.1.1.152
Thanks
Rodrigo
- Read more about Editable Fields
- 4 comments
- Log in or register to post comments
Determine the line number.
Forums
Hi There,
- Read more about Determine the line number.
- 4 comments
- Log in or register to post comments
Selecting checks via radiobuttons
Forums
Hi all,
I am trying to put together a script that lets me run a selected check on based on the appropriate VAT category by using radiobuttons. I tried basing the script on the one in the instructional video on this site, though i'm stuck at the radio buttons.
- Read more about Selecting checks via radiobuttons
- 7 comments
- Log in or register to post comments
Select mulptiple fields for operations
Forums
Hi all,
I want to create a script where users can select multiple fields and for example delete them.
I found the right snippet (Using listboxs to select files/fields) but don't know how to change the script to read the fields instead of the files and perform a task on the selected fields.
thx :)
- Read more about Select mulptiple fields for operations
- 7 comments
- Log in or register to post comments