Check Submission For Previous Records, Redirect To Update Datapage

[ChrisCarlson]

I want to create submission form, but want to check a table to make sure no previous entries are found based on 3 fields. If previous record is found I want to redirect to the record's update page. How would I go about setting this up?

[Jan]

Hello ccarls3,

 

Are these fields unique?

 

I can propose the following Schema, but I am not sure that it is the good Schema:

 

1) DataPage One - Submission Form that contains only Virtual Fields. When a user clicks the Submit button, he/she is redirected to DataPage Two, and all entered values are passed to the DataPage.

 

2) DataPage Two is a Search & Report DataPage with Predefined Criteria by these 3 fields.

The JavaScript checks, if the "No records found" is displayed. If yes, the user is redirected to DataPage Three, and all entered values are passed to the DataPage. If a record is displayed, the user is redirected to Single Form Update and ID of the record is passed.

 

3) DataPage Three is a Submission Form, that get parameters and then the autosubmit adds the data to the table.

 

I hope, it helps.

 

And I will look for more simple way