Link column / add new record: Understanding which fields are displayed (restricted views)

Your Setup:

  • SeaTable Self-hosted 5.1.9

Describe the Problem/Error/Question:

Before I raise this as a bug, I’d like to fully understand how this is supposed to work, and whether my expected behaviour is not how the system is designed. I thought I raised a similar question before, but coudn’t find it any more.

This is strictly Seatable backend, no Universal App involved (yet). We have quite a complex base, with linked tables and columns too numerous to mention. The main table, for example, has grown to over 100 columns.

My first question/issue: We have configured a linked column, restricted to a view, only a single link, linking existing records and creating new ones both possible in the link dialogue.

We expected that the columns / fields available in the “link record / add new” dialogue would reflect the "hidden columns " setting in the view that we configured. In pictures:

Hidden column in view “restricted”

We expected to not have the “type” column available when adding a new record from the link dialogue, but here it is:

So is our assumption wrong that “hidden columns” does anything to the “add record” form? What’s more, is there any way to influence the “add record from linked column” form? I noted when displaying a linked recording, the “hidden columns” setting from the target table/view is actually regarded.

This first question was just from a test database to figure out the general behaviour.

Second question comes from our production database. The link target table has 14 columns, 7 of which are link columns. That target table contains a central list of “people”, so they are backlinked to 7 other tables.

That’s where the problem starts: When I link to that person table, allowing a new record to be added, the form to add the record looks like this:

There seems to be no system in the way the fields / columns are (not) displayed. Some fields (single select, multi select, texts) are missing no matter what, of the 8 link columns, only 7 are displayed … we’re still trying to figure out what’s happening.

But getting an answer to the first question about the designed behaviour would help.

Thanks!

FORGET IT - I was sent down a rabbit hole by a colleague, assuming that she had checked the obvious. Sorry for wasting any time!

Doh! :frowning:

There is still an open issue which probably puzzled my colleague: Even if she chooses NOT to display link columns in the target table, they are displayed in the “add record” dialogue anyway

Is that by design?

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.