3 ms·
You need a basic CRM system, I think? You can probably build a simple enough one in Airtable for your internal users to edit easily, then make a separate relate
by solardev 3y ago
You need a basic CRM system, I think? You can probably build a simple enough one in Airtable for your internal users to edit easily, then make a separate related table for external users to submit forms to. Relate the tables by username or email or case ID, whatever you have. You can display all of that inside custom Airtable views (maybe good enough) or use the auto-generated APIs to make your own frontend.
If you want something more ready built, I think Zoho had a cheap CRM. Or maybe you can use a help desk type system like Freshdesk.
I think fundamentally this is more of a frontend and UX concern and not a backend stack question. Any stack can handle a few related tables, but you need something easy enough for your average user. Airtable and Freshdesk are OK out of the box, can be made better with some tweaking, and will probably be better than something you create from scratch with no frontend experience.