Hi,
I need the idea on the relation issue.
I make an automated quotation generator using Glideapps.
For example,
1st sheet is the general information.
Quotation No without Revision | Quotation No with Revision | Revision No | Revision +1 | **
** Customer Name | Detail 1… 2…3…|
Example: Quotation No is 2105-0001-Rev.0 (if New quotation)
It become 2105-0001-Rev.1 > 2105-0001-Rev.2 … (if its revised)
2nd sheet is the model information’s with all the long calculation
3rd sheet is the payment information’s
and etc.
Its all relation with quotation no.
My problem is I want to keep the data as this if revised:
Because currently it can add row at the main sheet only.
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…
but its copy and keeps on all sheets.
like have this in 1st sheet
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…
in 2nd sheet
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…
in 3rd sheet
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.0 …
2105-0001-Rev.1…
2105-0001-Rev.2…
etc…
Let me know if you guys not understand my question.