LinkedIn
Twitter
What would be the best way to run an expression that checks the recently added transaction log record and checks against a different table if it has the appropriate accounts and creates it if necessary? I have it almost working from a form submission (works when it needs to create the account, still pops up the form when it doesn't, but the fields are blank). I probably need it to work from an automation. The step does not show this action as an available option probably because an incompatible "do this" type.
Solved
1 ACCEPTED SOLUTION
Hi,
You can test the following process:
We have two tables:
InventoryLog[ID]
ItemMinMaxLocation[ID]
One action:
create a record in table ItemMinMaxLocation[ID]
One condition:
two values cannot exist simultaneously in the same item of ItemMinMaxLocation[ID]
PROCESS:
Every time an item is registered in inventorylog (event) we want it to check the table itemminmaxlocation[id] (condition) and if the condition is met, create a record (action) itemminmaxlocation[id] with data from inventorylog[log]
1ยบ ACTION We create the action (copyrecord)
- for a record of this table: InventoryLog
- do this: Data: add a new row to another table using values from this row
- table to add to: ItemMinMaxLocation
- set these columns: select
2ยบ - BOT
Event: New record table inventorylog[ID]
Condition:
COUNT(
SELECT(
ItemMinMaxLocation[ID],
AND(
[Location ID]=[_THISROW].[Location ID],
[Item ID]=[_THISROW].[Item ID]
)
)
)=0
Process
- Task: Run a data action -> copyrecord
BOT - triggers - conditions - tasks - actions
