Answered

Patch multiple records in one row

Like (0) Share

Report

Posted on 7 Dec 2021 11:33:30 by 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

Categories:

General Questions

Connecting to Data

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Gerard Simpson 2,987 Moderator on 07 Dec 2021 at 11:57:52

Like (0)

Report

Re: Patch multiple records in one row

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

Was this reply helpful? Yes No
twarb 28 on 07 Dec 2021 at 12:04:26

Like (1)

Report

Re: Patch multiple records in one row

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

Was this reply helpful? Yes No