General discussion

I am currently writing a script that i would like to search the entire database for terms. I utilized the history of a current project  but the code manually adds each field. is there a shortcut to add all fields from the database?
 
task.AddFieldToInc "ACCOUNT_NUMBER"
task.AddFieldToInc "DESCRIPTION"task.AddFieldToInc "DATE"
task.AddFieldToInc "NAME"

i keep getting a bad equation error when i run the extraction below. Je date and first are variables and first is a date that is entered in a text box.im thining my isue may be with the input text on the first variable.
 
task.AddExtraction dbName, "", je_date &  " == " & first

I need some assistaance with creating a script. Im trying to take the formula  below and replace it with variables based off an input box. i can get the code to run seperately but when i add the "or" it throws it off. Any help would be appreciated.
task.AddExtraction dbName, "", " CREDIT  >=  ( 1000000 )  .OR.  DEBIT  >=  ( 1000000)"
i have the following but am getting errors
task.AddExtraction dbName, "",   debit & " >= " & amount &  .or.    credit & " >= " & amount

Hi,
How's it possible to do summarization for a column containing a number (numeric field ) and to give it as reference the field date when I select "use fields from last occurence" ?
Thank you,
Ahmed.

Hi there.
 

Looks like CaseWare Analytics is going into the Cloud.  Check out this video to learn more.

http://www.caseware.com.au/caseware-cloud-analytics-video/

Goodmorning my fellow IDEA users, 
 
I'm having a relatively simple problem (i think) but it is driving me crazy: 
I'm trying figure out if it is possible to refer to a single record in the Equation Editor like it is possible in Excel with prefix $ in a cell?
 
Thanks in advance   
 
Dino

I just posted a new video on creating an IDEAScript from start to finish with a dialog.  It shows you what I think is the best way to put one together.

You can find the video here or on YouTube.

http://ideascripting.com/video/basic-ideascript-video-start-finish

Hi,
Pleas I need Help on one equation on Idea and this is my problem :
I got two files having column of the person’s name and I want to check with the function @SoundsLike the existing and no existing name on each file
How can I do this pleas

You can read what is new in 10.3 here (https://www.casewareanalytics.com/blog/what%E2%80%99s-new-idea-103)

The big thing for this web site is that IDEASCripting now allows scripts to be created in Python.  So I will be adding on Python resources as I have time.