Calculations with Text Input and Patch to Data Source

[Appy1]

Hello Everyone,

Hope you are all well,

I am a bit stuck, I have a Text Input within a gallery that i need to be 2 other text inputs added together. I also need it to patch back to my data source and update the cells within that. The problem is that isn't currently happening.

I am using this as the default property of that text input:
Round(TextInput1 + TextInput1_1,2)

The OnChange property is:

Patch(Calcs2,ThisItem,{'Payroll £ value ':TextInput1_2.Text})

Any help as always is very much appreciated!

Many Thanks

Chris

[SebS]

@Appy1 

Change Round(TextInput1 + TextInput1_1,2) to :

Round(TextInput1.Text + TextInput1_1.Text,2)

Than Patch if Your column is type Number

Patch(Calcs2,ThisItem,'Payroll £ value ': Value(TextInput1_2.Text))

[Appy1]

Hello @SebS 

Thanks for your suggestion, i have given it a go and seem to be getting an error on the Patch - OnChange.

Are you able to advise?

Thanks very much

Chris

[SebS]

@Appy1 

My bad forgot about {} 🙂

Patch(Calcs2,ThisItem,{'Payroll £ value ': Value(TextInput1_2.Text}))

 try again 

[Appy1]

Hi @SebS ,

Thanks, still not quite working unfortunately.

This is now the error received:

Many thanks

Chris

[SebS]

@Appy1 

Sorry, that must be me today 🙂 all that typos today not good 🙂

Patch(Calcs2, ThisItem, { 'Payroll £ value': Value(TextInput1_2.Text)})

[Appy1]

Thanks! @SebS 

Haha no worries, one of those days 😄 The formula now works and no error there.

Unfortunately it doesn't seem to be patching it to my data source though the cells happen to still be blank there.

Many thanks

Chris 

[SebS]

@Appy1 

The problem is not in Patch but in how you want to patch it.

You are using OnChange if the expectation is that when TextInput1 and TextInput2 will be input, that will trigger TextInput1_2.Text OnChange will never happen without physically pressing something that controls, so question is, in what control property are you using on change ?

[Appy1]

Hi @SebS 

Sorry i seem to have accidentally accepted the solution rather than click reply, i hope you can still help me please.

I think i understand what you are saying, is it that i would need a save button? Is that would your recommendation would be?

Thanks

Chris

[SebS]

@Appy1 

if you input data to text inputs in a sequence like  TextInpu1 than TextInput2 and after TextInput2 is submitted You want result of TextInput to be Patch to DataSource one of the options for You will be place code in OnChange of TextInput2 property other than that Save button will do the job