Skip to main content

Link any fileds

  • December 1, 2022
  • 2 replies
  • 36 views
S
Forum|alt.badge.img+5

Hello, there is a way to link a field to another table,other than the, master key field?
See attached file

Thanks

Sylvain

1 Attachments

      2 replies

      A
      Forum|alt.badge.img+10

      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)

        S
        Forum|alt.badge.img+5
        • Sylvain_Dionne
        • Author
        • Known Participant
        • December 4, 2022

        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)


        Hello, i am sorry but i tried and i can’t find how to paste the value to new column

        thanks

        sylvain

        Terms & ConditionsAccessibility statement