first of all I do have a dev background, so I’m open to implement something my self.
Anyway, I wanted to create a product roadmap with airtable and let my stakeholder vote/like on it.
There are two open points with this:
have a button so that you can click vote
allow non collaborators to click this button (this is not done to avoid paying for the appropriate plan, it’s just because my stakeholders are not part of the team so it would not make sense to involve them as collaborator)
I know I can use airtable API but that means creating a complete adhoc solution, my initial idea would be to just share the link to an Airtable that you cannot edit. You can only click on the button if you like it.
Yes, that would be very similar to sending them a blank survey form to fill out.
Unfortunately, there is no “direct way” to do what you are talking about natively in Airtable — showing them the current vote count. You could potentially do it if you linked your form’s table (the “voting” table) to another table (the “product ideas” table), and then showed them a list of linked records to choose from in the form (i.e. linked product ideas). Each product idea’s primary field could be a formula which shows the name of the product idea as well as the current count of votes, based on a rollup field which counts the number of votes in the voting table.
As you can see, this would take a little bit of time to setup, and this is the only way to do it natively in Airtable. Anything more complex than that, and you would need to turn to external tools to help you with this.
There are two tables: the [Choices] table and the [Votes] table. The two tables are joined with a linked record field. The [Votes] table contains the form that people use to enter their votes. As people enter their votes, the results are added up using conditional count fields. The buttons are "open url" buttons that have a formula that calculates the url that prefills the form with the proper linked choice and rating. You can use my Prefilled Forms extension to calculate the formula.