IDEAScript Questions

Hi,
I have to hide a column which is used for internal calculations. This column will be created from code and should not be visible to user by default.
I am using TableManagementLib.TableManagement to append field. I don't see any attribute in COMDBLib.Field interface for setting visible property.
Is there any work around for this?
Thanks,
Shafeer
 

Hi Brian
I was trying to perform from an Idea script some manipulations on excel cells. most of the manipulations works fine, but I could not find the equivalent to the folloing VB line:
 ActiveSheet.Range(Selection, Selection.End(xlToRight)).Select
this line select one row of excel cells from the current active cell to the rightmost non empty cell.
Naturally I tried the following, but it yield an error:
Set ex = CreateObject("Excel.Application")

Hi
Can anyone help me understand how to perform a many join?
I.e. a primary record in the resulting table for each record in the secondary table?
This is best explained in the pictures below.
Thanks

I stored field names in a array and tried to pass array as a parameter to a function but Idea threw an error.
sub main
      Dim fieldname(2) as String
      fieldname(0) = "Acct_num"
      fieldname(1) = "Acct_Desc"
      fieldname(2) = "JE_num"
       PrintArray(fieldname)
end sub
Function  PrintArray(Arrayname() as String) 
     for i = 0 to ubound(Arrayname)

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

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.
 

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.

Does anybody have an IDEAscript to run a macro?

Hello-

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