Jump to content
  • 0

Prevent submission



4 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:


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

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

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


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


Link to comment
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'



Link to comment
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.

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.

  • Create New...