@givemeawhisky Once again, thank you for your effort to help. To answer your question of permissions, the database itself is updated using a custom form to collect data from users, therefor it needs to have write permissions by members. The repeater is then used to display search results of information already collected in that same database (needing read permissions). This seems like a reasonable expectation of database functionality, collect data, search data, display results of search.
However, here is the really bizarre thing that I don’t understand. Using a custom form, members can input data, the database populates, and I can display that same data using that database in a gallery, great. Working as expected, no problem. It was when I tried to display that same data using a repeater that I ran into this problem. When I add that existing database to the repeater page and link the fields, nothing shows up as if data doesn’t exist for that field when it clearly does using other methods to display it.
Now, when I added a brand new database and manually populated data into it (which I absolutely do not want to do and makes no sense for my purposes) with the exact same permissions, it works. See the screen shots below.
Just why? The exact same data, the exact same permissions, the only difference at this point is the name of the DB and that I’ve manually entered in the data to the new DB. What gives? This doesn’t make any sense to me and why I’ve been banging my head against the wall for three days and reconsidering whether or not Wix was the right platform for my needs.
Since this new database works with displaying results in the repeater, my next step is to unlink my custom form fields to the old database and link them to this new database. Now, if my form breaks and users can’t submit data, then this defeats the entire purpose of a database for me and I will need to consider using another platform.
Finally, I realize that this is a forum for code issues, but there doesn’t seem to be a forum for community support on the functionality of Wix. Regardless, I do appreciate your help and I hope this information might help someone else who has this problem. I still have my ticket open with Wix and I can’t wait to hear if this is functioning as designed.
