Add validations on specific cells in a Table component

App Building
1

  • Goal: Add validations on specific cells in a Table component.

  • Steps: I have a table component that has a column defined as Percentage. If someone enters a value greater than 100, i want to be able to either change the value back to 100 or display a validation error message.

Could you please guide on how to achieve this?

Thanks

3 Likes
2

Hey @subbuiyer,

You can achieve this with a script that triggers upon a cell being changed and checking within the changesetArray property if the column in question is part of the array AND if it is higher than 100. You can then both trigger a notification and clear the changesetArray.

Let me know if you meed guidance on how to achieve this