Submit multiple records with Form

[vffdd]

Think I know the answer to this but just in case !  I would like to use a form to submit multiple records is this possible?  I don't mean using patch I want to use the SubmitForm functionality because I want to use the OnSuccess and OnError functionality but I need to submit multiple records (which are in a collection) Is this possible or am I stuck with Patch once it's more than one record?

TIA

[ppDev_30 · Accepted solution]

Hi @vffdd,

If I understand correctly, you're looking to submit multiple data entries to your data source using the SubmitForm function. However, it's important to note that the Form control is primarily designed to submit a single record at a time. For submitting multiple records simultaneously, the Patch function is more suitable as it allows you to add multiple records in a single action.

Although the Patch function doesn't come with built-in OnSuccess and OnError properties like the SubmitForm function, you can still manage success and error scenarios effectively. You can achieve this by utilizing functions such as If, Notify, or UpdateContext in conjunction with the Patch function.

Let me know if you need further clarification or assistance!

Thanks!

If this solution addresses your issue, please consider tagging it as the accepted solution.

[timl]

Hi @vffdd 

If your source data is in collection, it would be far better to Patch the records as it would be very tricky to automate the process of loading each record from the collection into the form and calling SubmitForm.

If you call Patch from within ForAll, you can wrap the call to Patch inside a call to IfError. That would allow you to specify the success/failure formula that you would have defined in the OnSuccess/OnError of your form.

[vffdd]

Thanks @timl  and @ppDev_30   Yeah it's what I figured.  It's just that it's a mobile app and coverage in the area is often a bit shaky ! and I find sometimes with patch that the record is not submitted correctly but I don't find the error handling as good as the OnError of a form !  so was just hoping I could use that functionality but with multiple records..   I'll explore the IfError a bit more

[vffdd]

@timl 

---

@timl wrote:

Hi @vffdd 

If you call Patch from within ForAll, you can wrap the call to Patch inside a call to IfError. That would allow you to specify the success/failure formula that you would have defined in the OnSuccess/OnError of your form.

---

actually could you explain that a little bit more?