IDEAScript Questions
How to append a field between 2 fields
Forums
Hi,
I have to append a field between 2 fields.
Suppose I have fields like ID, NAME, SALARY, DEPARTMENT, PHONE etc in my database.
I have to add a new field NETSALARY between SALARY and DEPARTMENT fields. Equation for NETSALARY field will be (SALARY-500).
How can I do this using idea script?
Thanks,
Shafeer
- Read more about How to append a field between 2 fields
- 2 comments
- Log in or register to post comments
Script to pass the prompt for first time control total calculation
Forums
Hello!
When using IDEAscript to run a macro to calculate the control total on a specific field, IDEA will prompt the user to accept calculating for the first time. Is there a way to bypass this using a script?
Thank you!
Shawn
Database Column Names
Forums
Hello!
I am currently attempting to create a macro using IDEA script.
We bring in a chart of accounts database and join it with another database. To ensure consistency I want to modify the name of one of the fields each time. The naming of the field may vary each time it is imported.
For example:
"DESCRIPTION_FULL_COA" to "DESCRIPTION"
The field will almsot always include the word description in the title. Is there a way to set the following with a variable/wildcard?
- Read more about Database Column Names
- 1 comment
- Log in or register to post comments
Accumulated Total and JE Number
Forums
I am trying to run a script that somebody else developed that creates an accumulated total field based on a user defined database and amount field and index and then create a journal number based on each set of transactions that the accumulated total nets to zero.
I am received the following error message "Error Code # 51, No cell Information", folowed by "Error on line 5999, No valid working directory"
- Read more about Accumulated Total and JE Number
- 10 comments
- Log in or register to post comments
Calling Ideascript using Action Link
Forums
Hi,
I'm relatively new to Idea Script. I want to call a script using an action link and I also have to pass a parameter.
How do I handle the parameter in the script? I want to pass that value to a variable but I couldn't find any info on how to do that.
Any help appreciated.
Thanks
- Read more about Calling Ideascript using Action Link
- 3 comments
- Log in or register to post comments
arrange columns with scripts
Forums
Dear All
Can anyone help me with how to arrange columns automatically? Now I just can arrange it from views and save as .VW2. I want it run automatically, please anyone can help me, thank you so much.
- Read more about arrange columns with scripts
- 6 comments
- Log in or register to post comments
Obtaining user details
Forums
Hi,
I have been trying to find a way to get the user details to pre-load a dialogbox with a possible path - eg C:\Users\jdgoodchild\Documents\IDEA9\Exports.ILB
Using set userprofile at a DOS prompt, I get USERPROFILE=C:\Users\jdgoodchild - just what I want. So I tried
Sub Main
Dim wshShell
Dim wshSystemEnv
Dim WScript
Set wshShell = CreateObject( "WScript.Shell" )
- Read more about Obtaining user details
- 5 comments
- Log in or register to post comments
How to use optional field to sort or index?
Forums
Hi,
I wanted to use a drop down list to select some columns and these are not mandatory selection, for example there are five criteria's provided, if user selected all 5 criteria (tagged 5 column/fields) I want to use all five fields to sort/create index and perform direct extraction using that index, if user tagged only one column then I need to sort the field using only that criteria and so on...
I am not sure how to use "task.addkey" in these conditions. Can anyone please help me with the code.
Thanks in advance,
Vijay
- Read more about How to use optional field to sort or index?
- 3 comments
- Log in or register to post comments
Export a manualy selected range of records
Forums
Hi,
first of all excuse my bad english.
I will export an IDEA file to excel. But I will only export the records I marked. (ctrl + left mouse klick)My idea is to mark the records (i.g. record-nr 1, 5 and 9) an then start a script to export only these records to excel. (or first to a temporary ideafile an then to excel)
Many thank for your help
Kind regards
Thomas
- Read more about Export a manualy selected range of records
- 2 comments
- Log in or register to post comments
how to turn screen refresh off
Forums
Hello,
First of all, thank you very much for this webite.
I am looking for a internal function within IDEA to disable the screen displayed during a macro run.
The same function function exist in VBA (Application.ScreenUpdating = False).
Thank you very much in advance for your help.
Kind Regards,
Mourad
- Read more about how to turn screen refresh off
- 7 comments
- Log in or register to post comments