Inventory List

AppSheet AppSheet Q&A
1

Hello Community.

I try to create an inventory app but i struggle with the automatisation.

There are three tables REF[Artikel], Parent[Intern], Child[Artikel Intern]

After creating a Record to the Parent Table [Intern], i want to get one of the following 2 options:

  1. An Action appear on the detail view of the created record on the Table [Intern] and after hitting this action, it automaticly add new records to the table [Artikel Intern], based on the data stored in the table [Artikel], with the option to set values automaticly with an initial value and based on a condition.

Or

  1. After creating a record the automatisation copy the rows explaind above, without the need of push a action button

I have no idea how to get this problem solved.

Maybe some one have an idea.

Many thanks in advance for every input and nice greets from Austria

2

You can try either

  1. Data: add a new row to another table by using values from this row

or

  1. App: go to another view within this app with [LINKTOFORM as a target](App column type (deep link) - AppSheet Help
3

Dear @TeeSee1

Many thanks for your Input, but i think that would Not Work.

I want to add rows, they allready exist in one Table, to an other table, based on a condition with a automatisation or Action.

No Idea how i should do this

4

@TeeSee1

You are right.

This Work for adding one row to a other table with sources from this table.

Not by adding, say about 20 rows from Table [Artikel] to Table [Artikel Intern] and also catch data from the table [Intern] Like the ROWID for the Reference to the Table [Intern] to [Artikel Intern] .

I need an Action or Automation in the Table [Artikel], that, after creating a new entry in the Table[Intern] with the Form in the Table[Artikel], put all Artikel from the Table[Artikel], based on a condition, automaticly in the Table[Artikel Intern] and Reference this with the ROWID from Table[Intern].

I hope ive explain this right

5

One way you could this is

  1. Create a control table to temporarily store the key value of the parent row you want to act on.

The columns of the control table (you can set security filter to make things simpler)

  • userID (key)
  • pid (ref to the Parent table)
  1. Create an action on REF(Artikel) to add a record to the child table (Add a new row to another table using values from this row)

  • p_id: Retrieve the parent id stored in the control table

    LOOKUP(
 USEREMAIL(),
 "control",
 "userID",
 "pid"
)​

  • Artikel, etc…

  1. Run the following action on the Parent table as a sequence of actions.

  2. Call a delete action on control table to clear any value used in the previous run

    • Either set a security filter on the control table or use an appropriate filter on USERID to target the proper record

  3. Add a row control table (Add a new row to another table using values from this row) to store the current row id of the Parent table

    • userID = USEREMAIL()
    • pid = [_THISROW]

  4. Data: execute an action on a set of rows

    • Ref table = Artikel
    • Referenced Rows: You set your conditions to select Artikel rows you want to copy to the child table (i.e. FILTER(“REF”, [copy status] = TRUE)
    • Referenced action: the action created in step 2 on REF(Artikel)

Depending on the conditions you need to apply to the REF table, this should work.

You can also set the grouped actions action to the Form save event.

There could be simpler ways but this should do the job.