Jun 25, 2021 08:41 AM
I am looking for suggestions of available front-end interfaces for Airtable. There are a few limitations of Airtable’s own form view are:
[[POSTEDIT: can’t have custom names for fields… incorrect, you CAN have this in the Airtable Form View.]]
no record edit function (just new record … yes I can do some tricks with Automation and linked fields to lookup field in the background but it would be ugly plus the linked field picker in the form view is limited… see my point 4)
formula fields not showing (as view-only formula fields; I want to show the results of the a formula based on values I am entering in the form + if editing existing record, the values may be based on existing values for the record already saved in Airtable
Linked field - record selection list - the list of records only shows the 1st field of the record once the form is deployed (when editing the form, the record snippet shows 4 fields including a picture);
4a) No lookup field - related to previous point.
Details for 4)
I am trying to lookup or get the highest used number in a field so that I know what’s the next free number I can use. (Auto-numbering will not work for me).
*There are different approaches like here for example… How to get max value of a set of records (in Airtable or via API)
The approach I take is using a Linked field to a view showing the record with the highest number.The issue is however, in Airtable Form, the lookup field list only shows the 1st field and that is too truncated.
I can solve it by concatenating the 1st table field to include the SKU number and then would see in the linked record search list… however, this solution is rather ugly… to show the SKU number at the beginning of the field because the field gets truncated in the field picker list.
Any suggestions for suitable web-form apps able to solve the points 1-4?
All I need is to create a simple and single web-form, creating maybe 500 records per year. No other requirements. Some of these solutions offer bells and whistles like storefront, payments integration etc… I don’t need all of that.
I believe of those 4 points above all would be valid features that Airtable should offer with their form and there would be no need to look for outside solutions…
Here is a list of 7-8 web-apps I looked up but haven’t tested them, some require signing up for a quite costly subscription even before I know it works the way I need:
(Seems Beenform is down anyhow)
Jun 29, 2021 06:02 PM
I don’t do a lot of elaborate stuff with forms, so Airtable’s built-in forms are usually good enough for my needs, and I don’t have a lot to offer to your questions. However, I will make a brief comment on this point:
You can customize field names in Airtable forms. Click on a field name in the form view and change it to whatever you want. The original field name is left untouched. This allows you to keep your actual field names short, but use something more descriptive when getting input for those fields from an Airtable form.
Jul 03, 2021 05:09 PM
I see, didn’t know I can change the name. That’s really helpful if the form is shared with others.
I am surprised none of the companies selling add-ons for Airtable I mentioned above haven’t picked up this post. This would have been a great way for them to introduce their wares. Not a single one commented (except for softr.io founder who did show up in another post recommending the platform,… . but as I commented there, that tool requires to subscribe to the most expensive level to even have the ability to edit existing record in Airtable… )
Again, I am surprised there are few comments in general. I could imagine taking Airtable to a completely new level if I was able to integrate it interactively with online forms… the sky would be the limit. (How about multiple tables or databases in a single form, that would be unbeatable…)
Since I am eager to hear from the aforementioned 3rd party solution providers, I will send out invites to see who is interested to respond and share with others here.
Jul 03, 2021 08:29 PM
It seems that on2air.com, softr.io and flairtable.com could be all same company - flairtable.com because their support signature says flairtable.com. Maybe all of them are using flairtable.com solution to handle support.
Jul 03, 2021 09:20 PM
I can give some guidance on On2Air Forms.
First, it is an integration into Jotform, so it does require a subscription (or free plan) to Jotform to use it. that is a downside in that it requires another tool, but the upside is you get the benefits that come with Jotform, which are many.
With On2Air forms, you can:
It cannot display formula fields for the current form as you’re typing. But you can use Jotforms Calculated fields to create a formula using current form field values. Its not as straightforward as I’d like but is doable.
We are working on some big changes to the forms product I can’t share just yet but exciting changes are coming from On2Air Forms, so if its not yet what you’re looking for, be sure to check back in near future.
You can use the free version of Jotform, and a free trial to On2Air to see if it works for you.
Jul 03, 2021 09:45 PM
Many of these companies are small companies that do not have enough staff to constantly monitor these forums for potential posts to reply to.
Jul 05, 2021 12:32 AM
Hey! Founder of Stacker here.
I think we’ll be able to help with some of your points:
Also worth noting – currently, we don’t have any unauthenticated forms, so this would be most useful for something where your users are logging in.
We’ve got a 30 day free trial – sign up and give it a try!
Jul 05, 2021 10:57 AM
@openside @Michael_Skelly Thank you for taking your time and responding here. I am grateful becauser it saves me a ton of time and I am sure others will appreciate, your answer here will give you exposure to more users. I will definitively test both solutions although one area where it will fall short right now is live computed fields, but hey, I understand now this is not a limitation of your solution but because of how things are processed with Airtable being a database so now I will need to think of some work-rounds around the live computed fields, I’ll look at JotForm. I appreciate.
Jul 06, 2021 11:36 PM
Hello! I’m Enrique, creator of Airvues. Our pro version lets you request a custom template which should be able to take care of everything you need here. If you need more information or have further question, feel free to reach out at firstname.lastname@example.org
At the moment as a small no-code Airtable integration service, we are working on creating more templates and customizations to be able to edit records and have more responsive forms.
To provide more information about question #3, since a record does not exist until the form is submitted, any formula fields won’t know what it’s variables are until the form is submitted. The way that Airvues can solve this is by replicating the formula in the front end so that it can update as you type in answers to the form.
I hope this helps!
All the best,
Jul 07, 2021 12:02 PM
That is great news. I am looking forward. I am a non-programmer, so only in the hindsight I realized the point #3 (where I am asking to have formula results showing real time as I fill in the form fields) … is a bit unrealistic to achieve within this framework.
But hey, since it may be possible to solve it, it would be great.
Here is an idea of what I was intending to do:
I created a sourcing-estimating tool for ecommerce by taking into consideration 100’s of parameters and one of the ways I would like to use it is to have a form, by entering some values and getting the profitability analysis.
I understand I am asking for too much but I am learning a lot by doing. A year ago I had no idea where this will go when I started.
Airtable is like a Lego, it enables small or big to build something, whether it’s just a toy or a proof of concept.
Thank you all.
Jul 10, 2021 01:57 PM
Don’t forget Airpress plug-in for Wordpress has the potential to be a free front end for Airtable. Documentation is limited at best though, particularly in the input from Wordpress to Airtable area (more help available for output, but still not great).
Have tried Softr for making a simple wiki style catalogue and that part works great! As far as manipulating or adding data though I haven’t tried - I think you need the paid subscription for that…
Jul 10, 2021 02:00 PM
Sounds like you could achieve what you want with an embedded Airtable form and some automations to me - as long as the data was returned via email or similar. Have you tried the “on form submission” trigger?
Jul 11, 2021 02:46 PM
Hi Joe_Hewes, welcome to our community and thanks for responding. I appreciate. Yes, it may be possible.
I am not a programmer. If you mentioned there is little documentation, well Wordpress may not treat people like me with kindness. That is assuming Wordpress can also edit existing records. If Wordpress can edit existing records, that would be very very interesting alternative.
Thanks for the info. I will work on changing the table so I’ll start looking into the forms later this summer.
Jul 11, 2021 03:02 PM
AirPress has very little documentation. Some WordPress plugins have great documentation; AirPress isn’t one of them. This is in part because AirPress is free. AirPress is capable of editing existing records using the the REST api. However the editing features in AirPress are completely undocumented, and not really usable by a non-programmer.
The main benefit of AirPress versus the other front end systems available is that it is free.