How does on build secure public apps with appsheet

[solomon_iseh]

Question that has held me back for 4 years since I joined appsheet. I have a lot of ideas and solutions I need to provide however the issue with user authentication makes the app very expensive and impracticable. If I have 2m users and I need them to view and enter data uniquely and securely , do I have to pay for everything one of them monthly… ?

[GreenFlux]

solomon_iseh:

If I have 2m users and I need them to view and enter data uniquely and securely , do I have to pay for everything one of them monthly… ?

YES.

2 million users x $10/month = AppSheet is not the best platform for all use-cases.

Apps are either secure, OR public.

You can link a datasource from a public app to a secure app. But if you need to filter data, securely, per-user, then you pay per user. (Security Filters, Pro Plan, $10/Mo per user)

Are the pricing levels not conducive to Marketing with an appsheet App? Questions

AppSheet is more geared towards internal business solutions. The platform does not provide a means for charging users, inserting ads, or managing subscriptions. There’s a good discussion on this from the July office hours video: [Chart updates and working with white labeling | July 14th AppSheet Office Hours]

Unfortunately, for your use-case and many others, AppSheet is cost-prohibitive.

Here are a few Alternatives:

glideapps.com

Glide – Create apps & websites without code.

Turn spreadsheets into powerful apps & websites, without writing any code. Pick a spreadsheet or start with a template, customize your app, then share it instantly with anyone. Start today for free!

appgyver.com

AppGyver

The world's first professional no-code platform to build React and React Native based apps for mobile, web and more. Sign up for the free-forever developer plan and get superpowers today.

Bubble

The best way to build web apps without code | Bubble

Bubble introduces a new way to build software. It’s a no-code tool that lets you build SaaS platforms, marketplaces and CRMs without code. Bubble hosts all web apps on its cloud platform.

directus.io

Directus: Open Data Platform for Headless Content Management

Directus is an open-source Headless CMS with the flexibility and power of a Data API. It allows managing both content and raw data, in any new or existing SQL database — keeping all your data pure, organized and portable, end-to-end.

Baserow

Baserow - Open source no-code database

Self hosted open source no-code database and Airtable alternative. Baserow gives you the powers of a developer without leaving your browser.

adalo.com

Adalo - Build Your Own No Code App

Adalo makes creating apps as easy as putting together a slide deck. Turn your idea into a real native app — no code needed!

[Ron_Mansolo]

Excellent options. For a web app you also should look at Backendless and Knack.

[MultiTech]

This sample app is from a video I made for my patrons:
https://www.patreon.com/posts/40934688

Public App - With Private Data

https://www.appsheet.com/samples/Publicly-available-but-with-userspecific-data-capabilities?appGuidS...

• This app (and the video from the post) shows how you can create a public app, that has the ability to link multiple devices to User accounts - and therefor show user-specific content on those devices.

[zonezsf]

MultiTech_Visions:

This sample app is from a video I made for my patrons:
https://www.patreon.com/posts/40934688

Public App - With Private Data

Public App (with private data)

• This app (and the video from the post) shows how you can create a public app, that has the ability to link multiple devices to User accounts - and therefor show user-specific content on those devices.

Hi @MultiTech_Visions - this is brilliant! I wish I found this post a month ago when I first found out about the $10 per user charge as I ended up going with Glide as an alternative with Appsheet as backup due to their pricing structure. Can I confirm if your app still works as you intended?

@Markus_Malessa - Hi Markus, not sure if you’re still here but I also spoke to sales and was told they can sometimes work out a discount for bulk users but I haven’t heard back with exact estimate yet. It will be very specific to each user. In the meantime, Glide has a great public with email plan that works for our exact situation. While I believe Appsheet is more stable from what i’ve been told, Glide also has a great team so we’re fortunate to have both of these options. Bubble, for me personally, has a higher learning curve whereas Glide and Appsheet both work off of Google sheet so easier to learn both. I also tried looking into Adalo and there was some reason that was a deal killer for my specific use case. sorry I can’t remember offhand what the reason was and for Appgyver, I think it was the UI blockiness that turned me off about it. (sorry, I may be getting this one mixed up with Adalo but one of them had a horrible looking UI builder compared to both Appsheet and Glide). Hope this helps!

[Markus_Malessa]

Although I am still waiting for someone from sales to contact me, it seems that once you have a need for many users that need to be checked against a login then Appsheet is cost prohibitive. But it seems that most other No-Code solutions are the same, and have a per user price that prices most outside what is possible also in my case.

Would be nice if Appsheet could come up with an intermediate plan that is based on either resource allocation or more geared on $X/Y users/mth or something similar. Otherwise I guess I am stuck with full stack in GAS maybe and using Firebase authorization or something else to authorize the end user.