Hello and Thank You for Advance
On GoogleSheet, they have the option to do for the Script Editor and I am wondering if AppSheet database have the same features.
On "Table1" where they have main columns such as "Name, Address, Phone, Email, Status, Sub Status, Date, etc" and depending on certain column "Status" and "Sub Status" is being selected by the user, a trigger will happens: Certain columns from "Table1" (Name, Phone, Email) are being duplicated and placed on new lines in "Table2" respective columns (Name, Phone, Email)
IF ("Table1[Status]" AND "Table1[Sub Status]") = TRUE
THEN DO/CREATE New Line on "Table2" with "COLUMN 1, COLUMN 2, COLUMN 3, FROM Table1"
This to me is too complex for me to archive since Im new with AppSheet, I appreciate if anyone willing to help me - Thank You
LinkedIn
Twitter
