Hello everyone :),
I have an app dedicated to manage transport. The app is dedicated to Packing list creations and transport following.
There is 2 tables:
TableA = list of packing lists (title of the packing with date of departure and status “preparation” “sent” “delivered”) 2 - TableB = packing details (detail of the parcels in each packing)
Problem 1: I need to update the status of TableB in function of TableA (When I change the status in TableA I need to update multiple rows in TableB). I managed it by using Virtual column but I would rather update the “real” data because I need to use it in another API.
Do you have a solution for this?
When the people are making the packing, they will enter multiple identical parcels. I created an action to duplicate but the problem is that it is time consuming to duplicate 100 times each parcel.
Basically, what I need is for exemple: within the form for TableB, an entry with “parcels N° from” then “parcels N° to” (ex from 5 to 9) and create a number of rows identical in each point except the CTN number (here five identical rows with number 5, 6, 7, 8, 9) I saw in the forum that it is possible with a script. Do you mean here that I have to make an onEdit Google script to update directly the data? Do you have any other Idea?
Thanks a lot