I am using API v2, on Skuid 12.4. Is it possible to create a new reference record if the one searched for does not exists?
I don’t know the differences between 12.4 and Latest version, but I think it should be possible.
Have you tried adding action on the model, where initializing event is row updated specifying the reference field, launch a java script to check if the model contains value of the field, if the value does not exist then update the model.
This idea might have holes in it, like row update to initialize the event might not be the best, might have to be launched on when the model is saved.
Also, this might be possible to fuse formulas instead of JS.