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!