Patch multiple records in one row

[twarb]

Hello,

I'm trying to build an app in which employees at our company can fill in job sheets and submit them to an excel spreadsheet. So far I've got the patch command to work with my date picker and one of my drop-down lists with separate "submit" buttons but ideally I want them to be able to fill out their jobsheet, hit the "submit" button and have that submit all of the input data to one row (i.e name, date, team leader, client etc) is there a command that can do this or do I have to chain multiple patch commands together? In the case of the latter how would I join these two patch codes together as an example?

Patch(Table3,Defaults(Table3),{'Team Leader': Dropdown2.SelectedText.Value})
Patch('Table3',Defaults('Table3'),{Date:DatePicker1.SelectedDate})

Many thanks
TW

[AmDev · Accepted solution]

Hi @twarb 

I though you meant multiple items (i.e. rows) to your datasource.

To patch multiple fields, just extend the record in your patch statement to include all the fields in your record like as follows:

Patch(Table3,Defaults(Table3),{'Team Leader': Dropdown2.SelectedText.Value, Date:DatePicker1.SelectedDate, otherfield: "etc", otherfield:"etc"})

Hope this helps

[twarb]

Hi again @AmDev 

Many thanks, I'm still a bit new to this so unsure of my way around some of the functions. Once again your wealth of knowledge has saved me; thank you!

TW