Hello, I am relatively new to IDEA scripting and have come to my first brick wall. Hopefully someone here may know the answer. I am trying to script a self updating database to keep track of inventory audits. My script runs in the following order:
- import product list
- import audit report of quantity changes
- join these databases, resulting in 2 columns from product list + 1 column from quantity change report
- export joined database overwriting origianl product list
- rinse/repeat twice per month.
This works great, but in order to continuously run the script the quantity change column header needs to be consistant. My plan to import that file with "current date" as the quantity header doesn't work as that date will keep changing. Is there a way to take the joined database, append a new field containing the quantity changes, and have that new field's name be the system date at the time the script runs?
if I can do that, this process will continually add a new dated column each time it runs. any thoughts?