Add data with 2 Condition to another table

I have some problem with my apps. Anyone some help me please

There are several steps to get what you want:

  1. In “Request Material”: Create a virtual column concatenating PIC&Material, call this as [PicMaterial]
  2. Make the [SOH ID] as PIC&Material of the SOH table
  3. Create a form saved action of the “Request Material form” that will add row to another table using value of this row to add PIC dan Material column, with “Only if this condition is true” of NOT(IN([_THISROW].[PicMaterial], SOH[SOH ID]))
  4. Make an action to set the column [IN] in the SOH table as formula: SUM(SELECT(Request Material[Qty], [PicMaterial]=[_THISROW].[SOH ID]))
  5. Create a workflow to fire that action for any new added row of “Request material form”.
1 Like

Dear Heru,

Point 2, i must create a “virtual column” too

No need. just make it as initial value of the [SOH ID] and use that as the key.
Almost forgot that there is another steps for the workflow to work, since the workflow will be from “Request material” table, which is execute an action on sets of rows. You will need to have a Referenced Rows of : FILTER(“SOH”, [SOH ID]=[_THISROW].[PicMaterial])

1 Like

Dear Heru,

for point 1-5, like this

!Point 1|602x500](upload://oezQVW8iY4expwTxKo0aPHIvRUO.jpeg)

or still wrong with my steps

this point 1 :point_up_2:

FILTER (“SOH”, [SOH ID] = [_ THISROW]. [PicMaterial]) -> where should I put it ?

There are several items required to be fixed:

  1. to have the SOH table allow for updates and add:

    please set the table like:

  2. this is not correct: and please make sure that it is an action in the SOH table:

  3. This action here should be the name of the new action in the “Requst Material” with Referenced Rows:

1 Like

Dear Heru,

Sorry, i’m revised for point 3-5 like this :

Dear Heru,

i still not understand with this :

FILTER (“SOH”, [SOH ID] = [_ THISROW]. [PicMaterial]) -> where should I put it ? :pray:

Please check this:

1 Like