Hi@Humanity,
Based on the issue that you mentioned, do you want to save data back to Google sheet?
Could you please share a bit more about your scenario:
- What is the relationship between the 'GasYear' and the other three sheet 'Natural Gas Bills', 'Natural Gas Bills 2', 'Natural Gas Bills 3'?
- How you configure your three Google sheets, provide your screenshot, or something example.
- What is the GasChoice, is it a Dropdown or anything else? Do you refer to it to decide which record to be updated?
Are there three Google sheet, each of which has an identical GasYear column? I assume that you distinguish the three Google sheets based on the value of the 'GasYear' column. The different values of 'GasYear' correspond to different data sources depending on the situation.
I think there is something syntax wrong with your UpdateIf() function. The following is a standar formula you can refer to.
UpdateIf( DataSource, Condition1, ChangeRecord1 [, Condition2, ChangeRecord2, ... ] )
The data source should be constant rather than a variable. You should put the If() function outside the UpdateIf(). You can check UpdateIf for details.
Further, you should refer to a value from the control within the data card rather than the column value. Replace the GasYear="1" with something like this, DataCardValue1="1".
I have a test on my side which is based on my assumption, please take the following workaround.
Connect Google Sheets connection to your App. At this step, please pay attention to the name of your sheet.
Make sure that you have referred to the correct sheet name.
Set the OnSelect property of the save button as below:
If(
DataCardValue1.Text = "1",
UpdateIf(
Sheet1,
GasChoice = Dropdown1.Selected.GasChoice,
{
Provider: DataCardValue4.Text,
Cost_GJ: DataCardValue8.Text,
Monthy_GJ: DataCardValue2.Text,
Admin_Fee: DataCardValue6.Text,
Delivery_Fee: DataCardValue9.Text,
Carbon_Tax: DataCardValue7.Text,
Prov_Tax: DataCardValue4.Text,
Fed_Tax: DataCardValue10.Text,
Other_Tax: DataCardValue3.Text
}
),
If(
DataCardValue1.Text = "2",
UpdateIf(
Sheet1_1,
GasChoice = Dropdown1.Selected.GasChoice,
{
Provider: DataCardValue4.Text,
Cost_GJ: DataCardValue8.Text,
Monthy_GJ: DataCardValue2.Text,
Admin_Fee: DataCardValue6.Text,
Delivery_Fee: DataCardValue9.Text,
Carbon_Tax: DataCardValue7.Text,
Prov_Tax: DataCardValue4.Text,
Fed_Tax: DataCardValue10.Text,
Other_Tax: DataCardValue3.Text
}
),
UpdateIf(
Sheet1_2,
GasChoice = Dropdown1.Selected.GasChoice,
{
Provider: DataCardValue4.Text,
Cost_GJ: DataCardValue8.Text,
Monthy_GJ: DataCardValue2.Text,
Admin_Fee: DataCardValue6.Text,
Delivery_Fee: DataCardValue9.Text,
Carbon_Tax: DataCardValue7.Text,
Prov_Tax: DataCardValue4.Text,
Fed_Tax: DataCardValue10.Text,
Other_Tax: DataCardValue3.Text
}
)
)
)
Note: DataCardValue1 is my corresponding control to 'GasYear', please replace them with yours.
Best Regards,
Qi
