"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?"
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.
User | Count |
---|---|
15 | |
10 | |
6 | |
5 | |
5 |