1

Prevent Duplicates Entries in Kissflow Form Tables for Enhanced Data Integrity

Do you want to prevent users from submitting duplicate entries in the process form tables?
You can easily achieve this with a simple aggregation field and a few formulae.

How does it work?
Sarah is responsible for managing the Purchase Order process at Stark Corporation. The form she uses includes a child table to collect order details. To prevent users from selecting the same product more than once in different rows, Sarah has implemented a system with formulas and aggregation fields that allow users to choose a product only once in the form table.

https://www.loom.com/share/fcf14ab8aed94d7b8a893b9b3a9dc5b4?sid=df27a9f4-97f7-4f6d-b53d-4c3bfef12ad7

Pro Tip: To prevent duplicates in a single form table column, enable the 'Mark as unique' option, which allows only unique values in the column.

Read more about the aggregation field here.

 suggested this use case to prevent duplicate entries in form child tables. While the unique column option is available, it can only be applied to a single column. This method has helped us prevent duplicate data in multiple columns of form tables.

Content aside

  • 1 Likes
  • 1 mth agoLast active
  • 1Replies
  • 52Views
  • 2 Following