nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Limit the numbers of smart multi-row // email all users indicated in this multi-row // build sum

Ulrich Bonda

Hi,

I want to limit the number of entries a user can add for a smart multi-row field

The question here was helpful, however, my current configuration only works with Validation Rule (Dataset), so it considers already created records. In Fact I want the validation to be applied before the record is created (count the numbers of entires of smart multi-row field and when it exceeds x, show error message).

I changed from "Validation Rule (Dataset)" to "Validation Rule" for the action to be executed, but this does not work with the same config in "Conditions"

Can anyone help?

Further questions:

- The multirow list contains (will contain, when submitted) recipients of the form. I tried to implememt the email notification via IFTTT (screenshot), but this only works when only one "inventor" has been submitted via multirow. If more than 1, the form tells me that "the recipient list is empty"

- The user is supposed to enter the contribution of the individual inventor in the multirow. The overall contribution must be 100%. I know how to set a condition that the single contribution must not exceed 100 but don't know how to simply build the sum and then validate the sum of all inventors' contribution

Accepted answers

Alex Medved _ConfiForms_

Hi @Ulrich Bonda

You can just have a validation rule in the form that has the multi-row field like this

Screenshot 2024-12-06 at 18.08.16.png

Screenshot 2024-12-06 at 18.08.24.png

Alex

All comments

Humashankar VJ

Hi @Ulrich Bonda

Try to develop a custom script that counts the existing entries before creating a new record. This script can be triggered before the record creation process, ensuring that the limit is enforced in real-time.

Sample Script:

#set($count = 0)

#foreach($row in $smartMultiRowField)

#set($count = $count + 1)

#end

#if($count >= 5) ## Assuming 5 is the maximum limit

## Show error message or prevent form submission

"You cannot add more than 5 entries."

#end

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

Alex Medved _ConfiForms_

Hi @Ulrich Bonda

You can just have a validation rule in the form that has the multi-row field like this

Screenshot 2024-12-06 at 18.08.16.png

Screenshot 2024-12-06 at 18.08.24.png

Alex

Ulrich Bonda

Thanks Alex, that's it!

I extended the original question, as my two further question are closely related. Maybe you can help here as well?

Ulrich Bonda

Thanks @Humashankar VJ

I found the solution from Alex easier to implement

Alex Medved _ConfiForms_

Not s good way to communicate (by changing the original question)

but do you want the emails to be sent individually for each inventor or a single email?

Ulrich Bonda

OK, will consider for future questions. sorry.

An email notification about a submitted form should be sent to all inventors (as indicated in the multirow) once the form has been submitted,. No need to send individual messages.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confiforms