Jump to content
  • 0
Sign in to follow this  
Shiro

Prevent submission

Question

Is there some way I can prevent the submission if none of my field is equal to specified value?

I have three fields on my submission form. I want the submission form to only activate if at least one of them is equal to yes.

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hello Shiro,

For this case, what I suggest is create another field on your data source table (preferably text 255) and check the unique checkbox. Then  on your submission form, set it to calculated value and make an SQL statement like this:

Case

When '[field:aaa]' = 'yes' then  SysUTCDateTime()

When '[field:bbb]' = 'yes' then  SysUTCDateTime()

When '[field:ccc]' = 'yes' then  SysUTCDateTime()

end

BAsically, what it does is it checks all the mentioned fields. if none of them is equal to 'yes', the value of this field will be null. However, since blank values are unacceptable on unique fields, it will prevent the submission. You just have to change the error message on the localization

Hope it helps

Quack

Share this post


Link to post
Share on other sites
  • 0

The timestamp is for making sure that the values will be submitted will never be similar to those previously submitted records. You may want to add some strings to it which is relevant to the Data you are submitting. You may refer to this one: 

 

 
CONVERT(VARCHAR(10), SysUTCDateTime())  + 'test'

Quack


 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...