I need to change the DateColuum only when a certain option is selected.
In the code below I get the value of the combobox in a variable and then I try to insert it in the ID of that data
When I put the" varBoxAtm" variable in the Patch function, it is understood as a "Record" type and not as a Date".
If(comboBoxAtm.Selected.Value = "Foo";
Set(varBoxAtm; Now()));;
Patch(
TBL_INFO;
{
DateColuum: {
ID: emergencyGallery.Selected.ID;
Value: varBoxAtm;
}
}
);;
Solved! Go to Solution.
Yes...you are setting the entire column to a record. Your syntax is not correct.
Please consider changing your Formula to the following:
If(comboBoxAtm.Selected.Value = "Foo";
Patch(TBL_INFO;
{
ID: emergencyGallery.Selected.ID;
DateColuum: Now()
}
)
);;
You don't need the variable to do this. I took it out. If you happen to need it elsewhere, just add it back.
I hope this is helpful for you.
Yes...you are setting the entire column to a record. Your syntax is not correct.
Please consider changing your Formula to the following:
If(comboBoxAtm.Selected.Value = "Foo";
Patch(TBL_INFO;
{
ID: emergencyGallery.Selected.ID;
DateColuum: Now()
}
)
);;
You don't need the variable to do this. I took it out. If you happen to need it elsewhere, just add it back.
I hope this is helpful for you.
It's even better without using the IF, thanks!
Excellent!