It would be great if I could use computed fields in collections. At the moment, computed fields could not be shown in collections like tables nor can they be used to sort our group tables.
Kind regards,
Dirk
Yes they can. Could you provide an example where you couldn’t?
There are some limitations when it comes to computed columns with Big Tables, but certainly none when it comes to regular tables.
Hey Darren, thanks for your reply. I have a relation Field in one of my Tables which shows the correct value for that relation in the Data-View. But I am unable to show this field when setting up a collection for that table. The field is not in the list. Is it an error?
Table in Data-View
Field not in List in Layout-View for collection
Kind regards,
Dirk
A relation just establishes a link between one row and one or many other rows.
It can be used as the source of a Collection, but it cannot be used in a component that expects a single value - such as the Title or Description in a Collection.
If you want to use a specific value from the row (or rows) that the relation links to, then you need to use a Lookup (single relation) or Joined List (multiple relation) to fetch that value first.
3 Likes
Okay, yes - that works. Thanks a lot!