SOLVED

SUBMITTING MULTIPLE FORMS

Brass Contributor

Hello Community.

Current issue...Complete Form 1, submits - Forms 1 & 2 submits - Form 2 was not completed

Complete Forms 1 & 2, submits - Forms 1, 2 & 3 submits - Form 3 was not completed... and so forth

 

Need to submit only the forms that are completed. 

If(IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1), !SubmitForm(Form1);

If(IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2), !SubmitForm(Form2);

If(IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3), !SubmitForm(Form3);

If(IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4), !SubmitForm(Form4);

If(IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5), !SubmitForm(Form5);

 

Any recommendations?

Thanks,

chudson002

2 Replies

Hi @chudson002 ,

 

Assuming that "IsBlank(QtrSel1.Selected.Value)" indicates that Form 1 has been filled out?

 

If so: 

If(IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));

If(IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));

If(IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));

If(IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));

If(IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

 

best response confirmed by chudson002 (Brass Contributor)
Solution
@BrendanE1535,
Thanks for the assistance. It put me further than I was.
The above submitted every form "except" the one that was filled out.
Did the above and added (!) .... and it all works perfectly!!
If(!IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));
If(!IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));
If(!IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));
If(!IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));
If(!IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

Thanks again for your assistance. This app is now fully functional and can move on to the next one.
Appreciate your guidance.

V/R
chudson002
1 best response

Accepted Solutions
best response confirmed by chudson002 (Brass Contributor)
Solution
@BrendanE1535,
Thanks for the assistance. It put me further than I was.
The above submitted every form "except" the one that was filled out.
Did the above and added (!) .... and it all works perfectly!!
If(!IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1));
If(!IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2));
If(!IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3));
If(!IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4));
If(!IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5));

Thanks again for your assistance. This app is now fully functional and can move on to the next one.
Appreciate your guidance.

V/R
chudson002

View solution in original post