IDEAScript Questions

How to:
1) Prompt the user to insert dates or text
2) Use the variable inputted as factor within task formulas

I have a script that first backs up prior idea files before it creates new ones. Some files though are locked and even if I use an error handler, the script still brings up an error prompt. Is there a way to force unlock using the idea script or suppress this error message?

Hello! I am trying to run the script which performs a joined database and summarisation. However, i am having issue with my summarisation where by the error message , i have try many ways to debug this but it doesn't seems to work. Wonder if anyone could kindly assist me on this! Thank you!

Hey guys,

Im trying to extract values from a table with the criteria being that the values in the columns have to be >= 30. This parameter, however, can vary. I created a separate Excel-table containing this value to ensure that other people dont have to go into the code and change it there.

I would like to add to my script a dialog box where the user selects the database that is to be opened and tested. I also want another dialog box where the user can enter a part of a output database name (like the year) and use that value in a variable to name part of the output table, if that makes sense.

So part of the output database name would be static, like Duplicates Payment Test and then add the variable for the year at the end.

Thanks in advance!

So far my code is pretty simple--it performs a join and extracts duplicates from the resulting database. However, I'm getting the following error when I go to perform the task in my duplicate extraction function:
 
"Invalid database name. The database name provided is either invalid or currently in use."
 

Hey there, I have a problem appending a new field to my database.
I built a function that takes a string from my database I'm appending to, and gets a string from anouther database that I need to be the value in my new Field... I get a error on my "task.AppendField field" saying there is a syntax error
 
 
Option Explicit
Dim LedgerTransaction As Object
Dim LTRecordSet As Object
Dim LTRecord As Object
Dim EntryTypeDescription As String
Dim ColumnName As String
Dim Number As String
Dim LTtask As Object

In Row 1 we have the closing balance
In Row 2 we will be using the closing balance of Row 1 as opening balance + Purchase - consumption = Closing balance
In Row 3 the closing balance of Row 2 will become the opening balance and this will continue, untill a new item witn opening balance is provided.
 
If we use the get previous formula all the data get freesed in that column and we cannot recalculate the amount in the same column.

We have frw isea script in .exe format, however the original .iss script is not available and we need to0 make some modifications to the original script.
Is there any way we can get the original .iss script from the .exe file created using ideascript.

Hi Brian,If i want get a cells value & then add it to the preious cell and keep on populating a column like that. Would it be possible ? For eg. in MS Excel, the same formula would like this = Coln A | Coln B| Coln C| 12               2             22               4            coln C = 12 + 4 = 16  ----- i.e.