Use button that refers to a text input field to edit excel tables, etc.

[gibson]

So there is probably a better way to do this, but I am just practicing right now and don't have any actual work data yet.

Say I have a text input, TxtOne, that says 'Hello.' I want to add hello to my table under SampleHeading. 

This is what I've tried:

Patch(Table1, Defaults(Table1), {SampleHeading: TxtOne})

I can't figure out how to link the button and text input, or how to to have TxtOne represent the values it's given. Any help?

[WarrenBelz · Accepted solution]

Hi @gibson ,

Close . . .

Patch(
   Table1, 
   Defaults(Table1), 
   {SampleHeading: TxtOne.Text}
)

I have a blog on Controls and their references that may assist you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[gibson]

Ah yes, I figured it must be a syntax error, it's frustrating that info isn't easier to find/clearer in the docs. Thanks! 

[WarrenBelz]

Thanks @gibson ,

Please remember to Accept as solution as this will help others find it more readily and also closes the item.