Skip to main content

IDEAScript Questions

How to Get Next Record Value by IDEA Script?

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

Creating a script to take the medain of a row across multiple columns?

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.
 

Open Documents - Hyperlink

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