I have a form that collects a bunch of data from users, and occasionally a user has a need to create several records that are related (share values for several, but not all columns). I created an action using Linktoform, that copies the relevant fields to my “New” form view. Because I only want this action to fire if the person has related records to enter, I created a number column asking the user how many related records they’re needing to create. Then I created another hidden column with the initial value of the first column minus 1. I set my action to only fire if the value of the hidden column was greater than zero, and my link to form reduces the value of the hidden column by 1.
I tested this action manually by having it “Display Prominently”, it worked as expected. I then set my form saved action on the “New” view as this action. It worked as expected, and if a user entered a value greater than 1, it would fire automatically until the hidden column had been reduced to 0. I celebrated my success, and moved on to the next thing I needed to build/fix.
After I got done tweaking my next change, this action no longer fired automatically when the form was saved. When I tested it manually by having it displayed, it still worked fine, and when I removed the condition that action only fired if the value of my hidden column was greater than 0, it would fire automatically again. I completely undid the change I made after I had everything working (though the two shouldn’t affect each other), but I cannot get this action to fire automatically with the IF condition under behavior.
When I test the condition in the expression assistant it accurately returns Y/N’s. It’s a very simple expression [column]>0, and I’m struggling to figure out what’s going on. Anyone had a similar experience, can suggest what I might be overlooking, or have a different way of achieving the same result?