Re: Error in patching the records
@Abdulazizhalawa
I cannot see any issues with your code. Sometimes after you run the code then get that Network error, your button / icon that holds the code will display a Red 'X' icon in the Editor. If you click on it, usually you will see where the error is coming from in your code. Maybe try this and see what it shows.
Also, to use a code window that I explained above you select it from the icons above your reply window, ie
Then copy your code into the window, ie
Set(prodctIDSelected,SKUsDropDowns.Selected.product_id);
If(
!IsBlank(CurrentValueInput.Text),
If(
(LookUp(clStandardValues, ThisItem.parameter_id = parameter_id)).standard_value <> CurrentValueInput.Text,
Set(LastValueID1,Max(clParameterValues,value_id));
Patch(clParameterValues, Defaults(clParameterValues),
{
parameter_id: LookUp( clParameterValues, parameter_id = ThisItem.parameter_id && product_id= prodctIDSelected).parameter_id,
last_run_value: LookUp(
clParameterValues,
parameter_id = ThisItem.parameter_id && product_id = prodctIDSelected &&
value_id = Max( Filter( clParameterValues, parameter_id = ThisItem.parameter_id, product_id = prodctIDSelected), value_id)
).current_value,
current_value: 15,
Reasons: LookUp( clParameterValues, parameter_id = ThisItem.parameter_id&& product_id= prodctIDSelected).Reasons,
user_id: LookUp( clParameterValues, parameter_id = ThisItem.parameter_id && product_id= prodctIDSelected).user_id,
submit_date: Now(),
product_id: prodctIDSelected
}
)
// I added these brackets below
)
)
