Error Message

"When the table reaches 30 rows, I want to display an error message when trying to add a record to the field as 'Maximum Record Reached'. I don't have coding knowledge, so I have been searching for help but couldn't find anything. Could anybody assist me?"

0 1 64
1 REPLY 1

You will want to use the COUNT() function.   You can create a expression like this:

COUNT("Select expression from table") > 30

Replace the "Select expression from table" part with a proper expression to select the rows from your table to be counted.

You didn't say when or how you would like to present a message to the user.  We would need details if you have a preference for this. 

One easy way to handle this is to add a Show column to the input Form that that displays your message and is shown when the row count is > 30.  Then also include validation in one of the columns that prevents Saving of the Form because the row count > 30.  the only option left for the user is to Cancel the Form.

That are many other ways to handle notifying the user.

Top Labels in this Space