I want a collection to have only unique records (no duplicates allowed). I want to create a new record and pass if the value is not present in the collection and that is working as expected. If the value is present, the creation is not allowed but also I am not able to retrieve and pass the record to the next screen.
For example,
ID, Name
1 John Smith
2. Joe Dane
If my input is Joe Dane, I want to pass the 2nd record to the next screen and if it is neither John Smith or Joe Dane, I want to create the record and pass it on to the next screen.
For context, I am following the below recommendation to avoid duplicates.
I finally used a list search and made the create button conditional. However, there is a bit of a lag before the create button visibility changes (to not display) and I am concerned how this would perform in the real world (particularly low bandwidth phones, assuming every search term change is checked against the database with roundtrip latency). If the data integrity is compromised, the business credibility would be compromised as well. It would be great to have a cleaner solution than workarounds (given I am already using lot of workarounds to fit the app to the constraints of the development tool, Adalo here)
Ah ok, you’re using the form… unfortunately, that’s not possible with the forms :((
If you use a regular button, then you can have a conditional action on create. BTW, may be my 1st advice wasn’t suitable due to the form - it can be used only with regular buttons.
Huh! It never occurred to me to do this without forms. Will try that. You have been super helpful. Really appreciate that.
Maybe time for a quick tutorial on when to use forms and when not to with pros and cons of each? I am fairly technical and using no-code for rapid prototyping but this kind of tutorial may help many non-technical app developers.
Hi @gani02, good idea reg. tutorial, thanks! Though it could be quite subjective. I’ll put that to my todo list - hopefully will find some time for this
