Hello,
To make a field value unique in a form, till date the developer has to write trigger or stored procedure to make a field value unique.
But now this is automated in Kaizen Framework.
Now you can simply tick the "Is Unique" checkbox while adding and field and Kaizen will automatically validate the field value.
Example: If you have a field "Customer Name" in the form and wants to make it unique. Just go to the field properties form and check "Is Unique". This will not allow user to enter the same data in "Customer Name".
You can also have various conditions for making a field unique. And to do that, you can enter column names of that Table in "Additional Field(s) for Unique" as comma separate.
Example: If you want the field "Customer Name" to be unique as per company then, you have to add the company field in "Additional Field(s) for Unique". If you want "Customer Name" unique with the company and location combination then you have to add company column name and location column name as comma separated in "Additional Field(s) for Unique".
You can however still have the option to write trigger or stored procedure if you want.
https://Kaizenframework.app
#lowcode #lowcodeplatform #lowcodeframework #rapidapplicationdevelopmenttool #radt
#Kaizen #Framework is a #lowcode, rapid application development tool. You can skip the coding, publishing, uploading task for making the software. You can save time and money while making complex web applications.
Download and start using Kaizen now.
Nesta página do site você pode assistir ao vídeo on-line Unique Field. Kaizen Framework. Low Code Platform. duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Kaizen Framework. Low Code, Rapid Development Tool 01 Maio 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 111 vezes e gostou 1 espectadores. Boa visualização!