Try changing the column Value: choices A, B, and C (and empty) are allowed; anything else will fail. This is done using IsValid formula column (it has to list out the valid choices), and an access rule that prevents Create and Update when newRec.IsValid is false.
The second table (Valid URL) is just an example of a formula thatβs true when the valid in URL is valid, and false otherwise. Not sure if thatβs all you meant. If you meant that this should control whether some other fields can be set, you can add an access rule similar to the one in the first example.
Hello ,
thank you very much
In your document , it was showing the value βDβ with a square red
when I forked it , i could create βDβ , even if it didnβt exist in the list , is there a particular reason ?
but after that , i was limited to only {ββ, βAβ, βBβ, βCβ}
And for the second case , what I meant is :
the user is allowed to check the checkbox to true (completed column ) only if the URL column is valid and not empty or another condition .