I have tried to use relations for that but it entails the column type to be multiselect and not text…
1 Like
Hi Ohad,
What do you mean with “sync”? Do you want a copy of the data in the new table, do you want to have a lookup in one table based on another table? Do you want to keep the entries in two different tables aligned?
R
p
1 Like
Hi!, sorry for the confusion. I’m not referring to a table view or to copy the table by itself, You know the relations column type? so basically that but the problem with relations is that it makes the column multi select and not free text.
1 Like
Hi Ohad,
The Relation column type provides you with several abilities. What you are seeing is strictly speaking not a multi select column. The entries are “links” to the entry in the opposite table.
In the image below, Cross-reference is a column type Relation. You can see that by hovering my mouse over the entry, it pops up the information from the other table.
Please provide more information on the underlying requirement, the community may very well be able to come up with something very close to what you have in mind.
P
Yes. entries are a better term to describe that. it just presents options from the other table’s column.
when I make a column a relation column, it is, by default like that. what do you mean by “Cross-reference is a column type Relation”? it seems like relations is a column type itself …
1 Like
The column under the green arrow above is called “Cross reference 2”
That column is of type Relation.
The entries in Cross Reference 2 are links to the entry in the other table.
Yes, that is the design of column type Relation.
1 Like
links to the entries? if I wanted the entries to be a text synced with the other column (on another table) would it be possible?
1 Like
No, because text type cannot be links. To have a link to another table, you need to have the relation type column.
1 Like
but the relation type column has to be entries that are on tables?
1 Like
yes. The relation table sets up a relationship to another table, and to a specific column in that table.
1 Like
we set-up this connection through cross-docs right? not through creating relations in specific columns between two separate tables?
1 Like
Hi,
What do you mean with “this connection”?
There are many different ways to link tables
- Using cross doc
- Using formulas to build lookup lists
- Using the relation column in different ways,
etc
If you provide more details about what it is you want to connect, and how you want to connect it, we can provide better guidance.
Regards
Piet
1 Like
Hi Piet,
basically we want to connect a text column in one table to a text column in another table. in such a way that if I type anything in one column it’s appearing on the other as text.
1 Like
You can use either a relation column, or a view, depending on what you are trying to achieve.
Autocorrect corrected.
1 Like
but if I incorporate view it’s technically a seprated table. I mean I guess I can position it near a given table but that’s not exactly what i’m aiming for. what is a realisation column?
1 Like
Realisation should have been relation…
Can you give an example of what you are trying to implement?
1 Like
Just a text column corrasponding with a text column in another’s table… does creating such connection requires formulas?
Is there a defined difference between relation and realisation?
1 Like
Realisation was an autocorrect error. I wanted to swype relation.
To establish a relationship between two tables can only be done via formulas. There is no other way.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.