As our business has grown over the last several months, we are finding a need to automate some redundant tasks. Is there a way that I could create a ROW in TABLE 2 when I add a ROW to TABLE 1 (When a certain field is VALID)?
Furthermore, if this is possible - could I have the new linked row auto populate with fixed fields or information?
Ex: Table 1 (Manual Input)
ABC Liquors / 123 Boulevard / John Doe 123-456-7890 / … / Conditional Field that yields NEW ROW Ready to Launch? (Y/N)
Table 2 (How do I add fixed fields in place, if possible)
ABC Liquors / Ready To Launch / …general info… / (Y/N) / Fixed Fields /
Anyone’s expertise is greatly appreciated!