Use an IDEA field if updating the data directly
Brian Element
Forums
In IDEAScript you can update the data directly in the cell by using the RecordSet and Record objects within IDEA. Usually you would first create the field using the field manipulation functions. If you create a virtual field and then try to do the update through the Record object the script will give an error. You have to instead create an idea field, what I mean instead of selecting virtual numeric, virtual character, etc you would select the numeric, character, etc fields and that will allow you to do the update properly.