Hi,
I have a checkbox like so in my browsegallery -
I want to change my status field on check.
I have this in my OnCheck property -
Set(statusupdate,"Complete"); SubmitForm(EditForm1);
however nothing is happening. How can I change my status based on check property for each record in my browwsegallery?
I think it should be something more like this
Patch(['Data Source'], ThisItem, {updateStatus: {Value = "Complete"}})
assuming the column name is updatestatus.
Trying this for patch
Patch(['Data Source'], ThisItem.Status_two.Value, Status_two.Value = "Complete")
also trying this -
Patch(['Data Source'], ThisItem.Status_two , {Status_two:Complete})
where am I going wrong?
okay just need help with why we are setting default property to this if statement.
what is this doing?
Use an IF() statement in the Default property of the checkbox to set the value of each item when you load the gallery. If you want to save the value when the checkbox is checked or unchecked Set an appropriate Patch() statement in the OnCheck and OnUncheck properties. the if statement would be something like
if(thisItem.statusupdate.Value = "Complete",true,false)
@Pstork1 thank you.
Which property do you mean as "Checkbox value" is that default or oncheck? -
What I have so far -
OnCheck = Set(gblRecordID, ThisItem.ID)
How should the if statement be setup?
Add the Checkbox to the Gallery Template (the first record in the gallery that you edit with the pencil icon). Then bind that Checkbox to the value of ThisItem.statusupdate as the default. You'll need to use an IF statement to set the checked property when the gallery loads and then use a Patch to save it since you are editing a Gallery and not a Form so there is no SubmitForm()
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional