Database Export (External sync), Permissions & Notifications

Ask the community
1

Guys,

We need a way to give back-end (read and/or write or both) permissions to non-full-admins of the site. That means if I have a limited admin setup for the client to manage pricing or access Wix mobile app and be able to take care of certain tasks themselves, I should probably have a way to give them access to the database that receives their user inputs as well, but I do not see such an option right now.

Additionally and along the same lines and for other technical reasons, it would be fantastic if we had an easy way to export databases or better yet if we had a way to sync up our live databases with an external spreadsheet or something like that so that data can more easily be shared with third parties who might need it (say in operation of a business) but should not necessarily have access to anywhere else on the back-end or front-end of the website (in my case for example, secretaries who call customers back, or drivers who pick them up, they have no business accessing site back-end, unless they can be fully only limited to the one database they are supposed to be able to read. Since that would be a lot more pain on dev side probably, asking for a Google Sheets Sync or a manual export option.

Lastly, is there any way to setup some sort of email or app-based notification method so that I (or other back-end managers) can be notified of any new user entries if we turned this option on? Not sure if any of this is doable right now using custom code, it might be, I’m a noob.

2

More granular permissions and back-end access
Hear you loud and clear. Back-end access actually might already work for site contributors, but I honestly don’t remember if we’ve implemented/tested this yet. Will get the answer for you though.
In the meantime, one way around this would be to create an in-site /manage page, or something of that sort - You could protect this page so only site members can access it, and have your ‘limited admins’ set up as users. Using input components and tables, you could allow both viewing and inserting/updating of the data. This would also give you a mobile-input solution.

Import/Export/Sync
Amen

Email-based notifications
Yes. It is indeed doable with custom code, in two ways at least.

  1. Call an external email/push notification provider directly. We have an example of how to do it with SendGrid. Not sure that example is up and live yet. Shout out if you want me to send you the code.
  2. Call IFTTT - my personal favorite method. By sending an HTTP call to IFTTT’s Maker Webhooks you can integrate with any of their gazillion connected services. Email, android, smart watches, salesforce, google calendar (here’s a temporary solution to that google calendar feature request of yours :slight_smile: ). If you don’t know how to get the HTTP call going, check out our implementation of fetch
3

=)) I had IFTTT setup on my phone to make a call to me whenever I badly needed to get out of a meeting back when I had a corporate job haha funny you mention it.

Yes I would truly appreciate it if you can try to fetch and share that bit of code. and I will look into IFTTT in the meantime.