November 1, 2022, 4:59pm
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.
November 2, 2022, 1:11pm
Can I please ask you to DM a magic link for us to test and see the issue? Also, please send the page URL.
Thanks in advance.
March 6, 2023, 4:56pm
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.
March 6, 2023, 5:08pm
It’s an improvement which is in our future plans. Still cannot mention any estimation, we should think of a better implementation plan.
March 6, 2023, 5:33pm
Thnx for the quick response. Looking forward to it
Hi Suzie, can our developer edit the code to make these linked records accessible/usable in the Softr portal?
March 10, 2023, 2:18pm
I am not sure if this can be done really, this is something our development team is struggling to find a solution.
I will make sure to keep posted once we have an update on this.
March 10, 2023, 10:58pm
@J_1 By “restrict linked records to a view” do you mean Airtable’s view ?
March 11, 2023, 8:08pm
@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 records from the all 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)