Apologies if I am doing something very stupid here, but I have spent most of the day stuck on this and I am more confused now than when I started.
I have a gallery and form from an Excel Online for Business data connection, so most values are being read from the spreadsheet using the Parent.Default value.
I have a column called "Disabled", which has a Yes/No value. The default in the system I am pulling the data from is "No".
I have a button that changes the text label from Disable to Enable, based on the value from the "Disabled" field. This is a Switch statement in the Text Property;
Switch(
UserDisabled.Text,
"No", "Disable",
"Yes", "Enable",
"Disable"
)
For the OnSelect property I want to set "Yes" if the existing value is "No", and vice versa.
As mentioned, when the existing value is "No" I have my "Disable" text shown on the button, and when it is "Yes" I have my "Enable" text shown, so this works.
I understand from reading up that I need to set a variable to access the Text property of the Text input field, I assume the variable is set on the "Default" property of the "Disabled" field, and that, as this is a single screen app I should be using "UpdateContext", rather than "Set", please correct me if I have that wrong. I have tried both.
When I have tried to set a variable I seem to lose the connection to the datasource(as I lose the "Parent.Default" value and don't seem to be able to use that as a value for a variable), and I also get an immediate error whenever I am using the syntax I have seen in various posts;
UpdateContext({varDisabledStatus: "whatever, incl. Parent.Default"...}), or Set(varDisabledStatus, "No").
And the corresponding If statement in the OnSelect Property of the Disable/Enable button shows an error as well.
I have stripped everything back several times and started again to try and avoid any variables persisting, but I am still getting nowhere.
I have 2 other buttons, Add and Modify, and they work fine, it is just this last one that needs to switch the existing read in value from "Yes" to "No" and vice versa.
Any help would be appreciated. Hopefully this makes sense?
