I have been trying to populate my blocks on softr.io with a “View” in my MARIADB DATABASE. I continue to get an error message that says it cannot find the primary key. This is understandable as “views” in mariadb don’t have a primary key. However I tried to create a unique identifier and other options like renaming a field to be ‘id’ to get softr to recognize it but to no avail. The only thing that is working is by creating a materialized table, but that is only a snaphshot and needs constant recreation. If anyone knows the correct solution, I would love to hear.
Thanks
mike