Hi. I have a problem with creating the correct formula or action to change values in a group in an enum column. After selecting any rows, I would like to use the value from the enum column for them, which is also dynamic because it takes data from another column. The data in this column is the name of the Warehouses, the number of which may change. I made actions for a single row by displaying another view in which I make changes and save them(go to another view within this app). Maybe a similar one can be created for many rows? I am asking for help.
Are you looking for a way to have a table be the name of warehouses and the connection to the warehouse choice enum column be a reference type to the table of warehouses
The warehouse table needs at minimum two columns Warehouse name and a key column.
The number of choices is dynamic as the more warehouses added the more choices given in that drop down. Also can change the names of the warehouses if desired in the future.
1 Like
No, no. Maybe I’ll describe it better. I have a table that ,has many different columns, it is a warehouse application with tools.
I will describe what I want to do. I want to select several different tools that I have entered into the table and change their storage. So that you don’t have to do it each time individually if you want to move a larger amount of equipment quickly. The name of the Warehouse is written in the enum column in the same table as the tool list.But there is a small catch - the warehouse takes the names from the second table which contains information about the warehouses, description, etc.
thanks
Okay so this will be a form for table lets call it “Equipment Transfer” . In equipment transfer we have a column that refs our Enum list of tools and an Enum list of warehouses.
We need to set up a bot that will adjust the equipments warehouse column if I understand correctly.
We also have a table called Tools and a table called Warehouses (For Explanation)
Also assuming that column [Warehouses] in table Tools is an Enum List type as well.
STEP 1 -
One action will be a set values of some columns in this table for the Tool table
The value for the Warehouse column will be
LOOKUP(MAXROW(“Equipment Transfer”, “_RowNumber”, IN([_THISROW].[Key], [Tools)), “Equipment Transfer”, “Key Column”, “Warehouse”)
STEP 2 -
We need a bot. Easiest/Fastest way to handle large data actions IF you plan to move mass tool inventory is with automation. We need to have the bot set up as an Event Source - APP and an ADD only.
Now the process build - we can go with a one step process. It will be a type - Run A Data Action. We want to choose “Run action on rows”.
Our referenced rows statement will be SELECT(Tools[Key], IN([key], [_THISROW].[Tools To Move])).
Last we select the referenced action to be the action we made earlier.
2 Likes
Thank you for your answers, I have to check this solution. I will contact you and let you know if it works. Thanks
1 Like