I have a problem that’s driving me nuts. I want to validate an input on a form to ensure it’s a unique value relative to the table it is being added to.
I have this validation formula:
thisTable.[YATS Lookup Column].contains(CurrentValue)=false
I had to create a duplicate column because it says it’s a circular formula if I try and validate it against the same column. But in any event this doesn’t work. Also tried doing a “find” on the column and validating that it’s <0 but that also doesn’t work.
So what am I missing? How do I set the validation so that if someone tries to submit an existing value it won’t let them (or, that it will only allow to submit a unique value that’s not already in the table?)
OG posters use case was actually a little different. can you explain your use case a bit more? More specific the better! There are so many ways to handle these kinds of workflow
I have to say ultimately this didn’t turn out to be something that could be done in Coda. Because the form sits on the “outside” of the doc as it were the only way to really do this was have people login to the Coda doc itself to enter the information. Because I can’t give access to everyone to this doc I had to solve this an entirely different way outside of Coda. I do think as a note to Codans forms need quite a lot of improvement to be truly useful. They are definitely the weakest part of the current codaverse and quite limited in how they can be used as a front-end to working with Coda doc data.
