Can we fail a Form Action

Hi,

We have a Form Action on NUX that creates a list item and then adds values to certain line items. It was setup as per the requirement but now we want the action to not proceed if the difference between Start Date and End Date (both mandatory line items in the form) is beyond 30 days.

Is it possible to fail the action somehow if the conditions aren't met? I know that forms sit on top of the model so I cannot use Read/Write access to stop a mandatory field from being filled. Let me know if you have any ideas.

Accepted answers

ryan_kohn

As @rob_marshall indicated as well, Forms do not currently support pre-submission validation for the fields you're looking for. There are only additional validation options for text-formatted line items. The only way to provide validation for data ranges is after Form submission (or using another method of submitting values without leveraging Forms).

There are a variety of techniques used for validating user input after submission, most of which are outlined in this two-part series on validation: https://community.anaplan.com/t5/How-To/Part-1-Validating-user-input-in-Anaplan-Approaches-and/ta-p/143320

There are also some relevant open Ideas on the Idea Exchange. You can add your commentary and use case to an existing issue, or if none of them quite capture the need, go ahead and submit a new one and post the link back here so we can kudo it!

All comments

rob_marshall

@ankit_cheeni

Create a validation line item that is formatted as a boolean with the logic: (End Date - Start Date) > 30

And then use that line item as a filter for a view that the action uses.

ankit_cheeni

Hi Rob,

I was talking about Forms on NUX that would help us create items in a list. Sorry if that wasn't clear.

rob_marshall

@ankit_cheeni

No, you were clear, I was just advocating for a different way, using an action. Sorry if I wasn't clear on that.

Rob

ankit_cheeni

Yeah seems like the easiest and simplest thing to do. Thanks for validating!

ryan_kohn

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?