Dec 01, 2022 01:51 PM
Dec 01, 2022 04:26 PM
Hello, you can create a column with type "Linked Record to Table 2" in Table 1. Let's call it "newColumn". Then you can set an automation which pastes the value of Portes Fabriques to newColumn. By this way you build the link with tables. Since the second table's first column is in formula type, the pasting automation does not work if there is no record in Table 2, already with the name of Portes Fabriques. Therefore, newColumn is not empty if there is a record with the same name (of Portes Fabriques) in Table 2. If there is no such record, newColumn is empty. This can be enough, but you can also create another column with the formula: IF(newColumn = "", 0, 1)
Dec 04, 2022 09:51 AM
Hello, i am sorry but i tried and i can’t find how to paste the value to new column
thanks
sylvain