I’m having trouble when editing records in a Table block that connects to an Airtable “Linked” field. There are many (~1,000) choices to link to. The Softr editing seems a bit buggy.
Drop-down list of choices available to me when editing record in Softr is apparently random subset of full set of choices in linked table in Airtable
Area to view/edit existing entries (linked records) when editing record in Softr sometimes disappears
Sometimes when I add a new linked record, it replaces existing linked records rather than adding to the list
Existing entries (linked records) when editing record in Softr are sometimes abbreviated, sometimes not (e.g., if linked record is “Jane Smith 456”, sometimes Softr just lists “jane”).
Issues 1-3 seem related to scrolling within the Edit Record interface and seem to resolve when I “cancel” out of the edits and refresh the page.
About issue 1.
Is a solution/fix planned for this?
The fact that we can’t limit the options open to a user when he/she has editing permissions for a linked record field that should have restricted options, is a bit of a show stopper for us right now.
Example here shows both the options for “age” and “expertise”, while the linked record field in Airtable is actually restricted to the “expertise only” view
Most logical solution and ideal solution would be Softr honoring the “restrict linked records to a view” fields setting we’ve setup in Airtable itself.
@artur Yes exactly, when pointing the Softr to below Airtable field, which is a Linked Records field pointing to the Groups table and restricted/limited to the view ‘Expertise’ (screenshot 1), Softr provides all records from the Groups table as options in the edit modal. But 37,38,39 shouldn’t been available/shown as options when limited to the expertise view (screenshot 2)