350
Here's the code I'm using. Nothing seems to work. Instead of adding and subtracting the inventory it only inserts the number in my text box. Instead if should add or subtract from the inventory. Any help is much appreciated.
Patch(
tblOptrackInventoryImportedDataCSVS,
LookUp (
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value
),
{ON_HAND: Value("ON_HAND") - Value(txtQuantity.Text)}
);
Hi Laurens, hope you're well. I have a gallery list when the user clicks on a field on the list my app takes them to the detail form. I cannot seem to find the syntax to make the dropdown defaulting from the selected item in the list.
So this inventory portal I'm developing has to add the inventory to warehouse and subtract from warehouse.
One of the warehouse is used to replenish inventory. Here's my code I'm wondering if we can combine or shorten the code a bit.
I deduct the from warehouse and add to warehouse.
With(
{
//Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value
wLookUp: LookUp(
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value
)
},
Patch(
tblOptrackInventoryImportedDataCSVS,
//Use function variable as record reference
wLookUp,
//Use function variable to reference the current ON_HAND column
{ON_HAND: wLookUp.ON_HAND - Value(txtQuantity.Text)}
)
);
With(
{
//Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value
wLookUp: LookUp(
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_To_Warehouse.Selected.Value
)
},
Patch(
tblOptrackInventoryImportedDataCSVS,
//Use function variable as record reference
wLookUp,
//Use function variable to reference the current ON_HAND column
{ON_HAND: wLookUp.ON_HAND + Value(txtQuantity.Text)}
)
)
Hi @rroque,
Value("ON_HAND") does not refer to the value in that column but rather performs the Value() function on the text value 'On_HAND'. When you want to add / subtract a value from the current state in your table, you can combine the With() and LookUp() functions for easy reference to that current column value.
Share
Report
All responses (
Answers (
With(
{
//Temp save LookUp value to a function variable for easy reference in the Patch and for the ON_HAND value
wLookUp: LookUp(
tblOptrackInventoryImportedDataCSVS,
FORM_NO = ddl_Form_No.Selected.Value && WAREHOUSE = ddl_From_Warehouse.Selected.Value
)
},
Patch(
tblOptrackInventoryImportedDataCSVS,
//Use function variable as record reference
wLookUp,
//Use function variable to reference the current ON_HAND column
{ON_HAND: wLookUp.'ON_HAND' - Value(txtQuantity.Text)}
)
)
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
