IDEAScript Questions

Hi Brian,
 
It's been quite a while since I've had a question and I hope all has been well with you and yours over the last couple of crazy years.
 
I'm currently working on a script and I have a question on using visual connector.
 
My script is joining several files to a primary file using visual connector and it's working.
 
However, I am using task.IncludeAllfields which is giving me a lot of unnecessary columns in my output file.

Hello, has anyone, please, been dealt with this issue? I am preparing a macro to be able to compare 2 databases which includes names of persons, and find the matches. There can be several gaps in the names and the individual words can be in different order in the databases.  Therefore I need to create in each database a common field for the comparison – a name field with individual words sorted alphabetically.
Preparing one of the databases for comparison:
Default state:

Im trying to create a new column   ("FILE ID")    that contains a value from another one. I want this value to be repeated by "Codigo". Everytime "Codigo" changes, The "FILE ID" column must have the new FILE ID. This value can be repeated, and "Codigo" can be repeated too.

Hi!
 
I am working on a function that would validate dates. I am aware of IsDate(), but it doesn't really suit my use case as it only accepts Date types and the two inbuilt conversion functions DateSerial and DateValue, will convert invalid dates into valid dates, by addding the excess months and days into years ( for example 01.13.2020 becomes 01.01.2021). Therefore i am writing my own implementation. 
As part of this i have a funciton that strips the string into day, month and year and converts them to integers:
 



hi, 
 
the guidelines found in the help tab of IDEA outlines the following guideline (among many): 

Hello I would like to ask for a help to fix my program.
Only the function to remove fields is not working, it shows the error of not recognizing the name "Date3".
I have tested several ways but have not succeeded, always accuses the same error. 
Thanks in advance
Elaine

Hi everyone,
I hope you are doing great. I would like to ask for a help.
I need a script to update a historical information and for that I renamed a column using a dialog box, but it is not working.

Hi all,
 
I was wondering if there's a function or script that's similar to the "Sumif" formula in Excel? I'm trying to eliminate expense reversals and in Excel, I use the following sumif formula to achieve this:
=IF(SUMIF($BA:$BA,$BA2,$AU:$AU)=0,"Yes","No")
Where column BA is the unique expense number (which can be the same if there's a reversal of expense) and column AU is the expense amount.

Hello, 
I have a macro that I use on a weekly basis. In the macro I have a spot for an input date for the weekly analytics. This input date is always the previous Monday date, for example next week when I run the macro the input date will be 03/07/2022. 
I also have an input date for analytics where I use five weeks of data. This input date is always the fifth Monday from the current Monday, for example next Monday the input date will be 02/07/2022. 

Hi Brian,
I hope you are doing great.
I have created a dialog box in a few days so I added a couple of keys and editbox in diffrenet places on my dialog box.
When we run the dialog to fill the blank boxes out, if we use tab key on the keyboard, the orders is based on the order we have created.
For instance, afterI filling out the project name, it goes to Help button, then it goes to Entity codes and so on. Is it possible to change the orders based on the order on my dialog box?
 
Thanks,