In a Canvas App, how to build a form that writes to multiple tables?

[SinLeeNg]

Hello everyone,

I have a scenario with the following requirements for a form, say it is regarding records about Animals:
- on new/edit Animal form, allow upload of max one Excel file, saved to DataVerse

- however, on edit Animal form, the Excel file uploaded should not overwrite the existing Excel file

- when viewing the Animal record, the canvas app should only show the latest Excel file

So, over time as the user edits the record, in DataVerse there should be a history of Excel files per Animal record and a way to download these Excel files.

I am thinking that most likely the Excel files are stored in another table, with a lookup to the Animals table, hence the subject of this question. However, I may be wrong and I hope to be enlightened and get help on building out the form.

Thank you all in advance!

[Pstork1 · Accepted solution]

Forms can't be bound to more than one table.  So you won't be able to use SubmitForm().  YOu can use multiple Patch() statements to create or update records in multiple tables at the same time using a form or forms for the data.  Its more work, but Patch gives you the control you need to save things to multiple tables.