Re:Show HN: Turn an Excel file into a web application
by davidpolberger on Tuesday May 21, 2019 @06:57AM
(#19969009)
Calcapp may be what you're looking for. You can validate text fields using regular expressions and there's an example of how to validate an e-mail address here: https://www.calcapp.net/learn/beyond-numbers.html#validating.... Fields can be pre-populated with either values you know ahead-of-time or through Excel-like formulas.
(I'm a co-founder of Calcapp.)
Re:Show HN: Turn an Excel file into a web application
by mgkimsal on Tuesday May 21, 2019 @07:03AM
(#19969039)
> enforcing ownership of that email.
I believe the GP was talking more about "click here to confirm your account" type validation, not "does it have an @ in it".
Re:Show HN: Turn an Excel file into a web application
by theothertom on Tuesday May 21, 2019 @08:03AM
(#19969316)
You can generate URLs that pre-fill Google Forms, they're just ugly and have the all the pre-fill in the URL as query parameters
Re:Show HN: Turn an Excel file into a web application
by EGreg on Tuesday May 21, 2019 @07:48AM
(#19969243)
Yes. We can make one in 30 minutes with https://qbix.com/platform .
But what is the goal of this? I want to understand since it sounds like you need real PROFILES for reusable personal data.
(1) Getting a _validated_ email address of the submitter. It does support an email field, but makes it a free-form text input with no way of enforcing ownership of that email.
(2) Pre-populating some of the fields when we send the user to a form via a link. Without this, the user ends up filling the fields even though they have already submitted that information in another form.
Are there any powerful (forms + spreadsheet) products out there that solve these (and are cheaper than, say, AirTable) ?
(2)