I have made a booboo.
I have Softr connected to Airtable. All was working fine.
I decided to tidy up my field naming, so went to my User table in Airtable and changed the field names (for example from “User Manager” to “user_manager”). It then dawned on me this might be an issue, so I tested it after only changing the User field names. It had broken something and it said it couldn’t find the field I had mapped as the User unique id (the email field).
I changed the names back, and to check it was OK I added a new user, then re-sync’d Softr users back to Airtable. That worked and just to test I added a new user in Airtable and that too came across to Softr.
But, but, but
When I use a magic link to log in as one of my users (which worked until I made the changes) I get the header (including the icon to show I am logged in) but the home page is blank. As are all the other pages.
I can click on the user icon in the header and it triggers the User Profile page, with the right email and user name, but if I make a change to the name and click update nothing happens. Again as a test I added a new User Profile block to the same page. So two blocks, my original and a new one. When I use the original the button does nothing, but the new block works fine and updates Airtable with changes to the users name.
I created a new list block on the home page to display all my users, then published and tried that. It works, the users are listed. I added a new hero block to the home page and again, that works.
All of my original pages and blocks appear as expected in Studio, I can see them, edit them, they show data as expected in Studio. But they don’t appear on published pages.
I have tried duplicating the blocks, that didn’t work. I also tried refreshing the Connections to the blocks, no luck.
I don’t know what I’ve broken that those pages don’t appear any longer when I publish?
Thanks for any help