Still working on Knack migration. In my “Documents” table in Knack, the unique key (i.e. document name) is a concat from other fields, i.e. {Doc Type},{Year},{Sender}. However Sender is a connection field from another table (Senders). In Tada, when trying to assemble it via Equation field, it seems you can’t use connection fields (only {Doc Type} and {Year} show up). Is there any way to do it?
Text Formulas in this case are useless as they can’t be referred to in imports.
1 Like
I see that your question was never answered. I just posted a detailed explanation of the problem and a solution here:
Filtering on connected field values - Community Discussions / How Do I - Tadabase Community
It’s definitely not an ideal solution, but it does seem to work.
ADDED 1 DAY LATER (4/11/22): Sorry I just reread your original post more carefully and the problem you were dealing with is not identical to the problem my post addresses. But it is pretty similar and I suspect the two-field approach I described would work for you. The idea is simple:
Recapping the problem: As you saw, you can’t reference a connected value in an Equation field. So
- Create a Text Formula field to “capture” the connected field. Text Formula fields can reference connected fiels.
- Now create your Equation field and reference the Text Formula field created in the previous step.
I just tested it as I think you would be using it and it seems to work.