Unable to "see" the desired single select items in field

Hello, we build videos for clients which go through multiple draft revisions through a project. I am working on a project management app, specifically a panel to collect feedback relative to a deliverable version.

  • The feedback module I am building is a softr table referencing the “feedback” table (air table)

  • Airtable has the following Tables: Projects, Drafts, Draft Feedback

  • Feedback lands in the “draft feedback” table, and each should contain the “project” and “draft” that feedback comment is associated to.

The feedback module is placed on the project details page.

The page is based on an item details block pointing to the project base but ALSO contains multiple item details blocks, each pointing to the drafts base with conditional filtering to specific draft versions

The feedback module table has an action button enter feedback. The action button has a long text entry field and a hidden field to pull in the linked project name and a hidden field to pull in the user name

Here is my problem:

The original design idea was for that same action button to also contain a hidden field to automatically pull in the related draft version (which is a single select field in the draft base) so we would know which draft they are commenting on. But I cannot get that to work, likely because the draft feedback module doesn’t know which draft is being commented on.

While I would really like that idea to work, I cannot spend much more time on this problem, so I am changing the design to using a real data entry field for the user to input which draft they are referring to when making the comment, preferably with a dropdown that shows them the available drafts that have been created. But I cannot even get this to work either.

I am not a developer and am stuck here not knowing if the problem is from the database design, softr setup or softr capabilities?

Please help!

1 Like

Hi there, can you use a linked field in Airtable to store that “draft version” onto the related record? If you can do that, then it will be accessible via the hidden fields option.

Understand Over My Head GIF by ABC Network

We recently put together a 3 hour, step by step course to help new users get started with Softr. Maybe this could be a good resource for you to learn a bit more about structuring your DB and building your application?

https://academy.softr.io/course-details?recordId=recnFKgeqf4X51k85

Otherwise, I was trying to say that Softr can only read the data that is available in the specific record, and cannot read related tables of that specific record.

So, in the list block that you have in the preview, if you can add the information for the version number to that table/record, then you’d be able to use hidden fields via the action button to save which version the user is commenting/editing, etc.