I have a button with the Onselect as the formula above. I have a collection with 4 columns, one of which is called "TestNewTemp" which when created in the collection is set to Blank(). When creating the formula it lets me auto populate 'TestNewTemp', however Im getting an error. The error states, 'This type of argument 'TestNewTemp' does not match the expected 'ObjNull' found 'Text'. Does anyone have any idea what I'm doing wrong?
So I've figured that its because when creating my collection, I'm creating the "TestNewTemp" column using Blank(), I changed this to "1" as a test and now my patch formula works. Does anyone know another way to create columns in my collection that's have no value without using Blank()

Report
All responses (
Answers (