Nextcloud automation - form response to database or table ?

[timconsidine]

I'm looking to set up a simple form and log responses in a database.
Nextcloud has nice simple form capability, but it requires manual intervention to save response in a CSV and then a manual interaction to get that into a database (or possibly a spreadsheet).

n8n doesn't seem to support many Nextcloud actions.
Nextcloud scripting doesn't seem very developed (or I haven't seen a suitable workflow).

Maybe Nextcloud is not the best option, just trying not to re-invent wheels.

Any thoughts/suggestions ?

[jdaviescoates]

@timconsidine said in Nextcloud automation - form response to database or table ?:

Any thoughts/suggestions ?

Sadly all I can really suggest is to chime in here:

https://github.com/nextcloud/forms/issues/5

And in the meantime, use LimeSurvey, I guess

[robi]

We have NocoDB and Baserow too, and as @marcusquinn will chime in with WP can do this too via plugins.

[timconsidine]

Thanks @robi
I'm using Baserow but not happy with it.
I tried NocoDB, can't recall why it didn't suit, will look at it again.

[timconsidine]

@jdaviescoates saw the thread but it is locked.
Will find some way to raise it.

[robi]

@timconsidine said in Nextcloud automation - form response to database or table ?:

I'm using Baserow but not happy with it.

Nod, I was looking for a similar reason recently since there are things like pory.io for airtable to make things "happier".

I haven't found a good way to describe that category that nicely front ends low-code DBs, to find OSS options.

[robi]

@timconsidine The dev from https://convoworks.com just reminded me on Twitter of the nifty stuff he's doing.

He's testing his new chatbot here: https://convoworks.com/?p=5015&preview=true

[timconsidine]

@robi thank you - will check it out

[marcusquinn]

@timconsidine I'd probably go WordPress + FluentForms (all their other plugins are very god, too). That way you have all the standard WP API endpoints, and every ETL app can handle those.

Fluent also has plenty of it's own integrations, and WP Fusion can also be good for integrating with another CRM.

[luckow]

@timconsidine i have the feeling that something is missing. nobody needs a form whose data is transmitted to a database. everyone wants to do something with the data. what is the purpose of your project?

[timconsidine]

@luckow yes, true, but I want the data in a database so I can make a web view to view form submissions and print a page for reference.

The form is a registration form
Baserow and Nextcloud have no print facilities for the viewed data.
(Nor NocoDB either, I think, and its form is not nice)
Yes, of course I can log in, save submissions as CSV, download a CSV, open it in a spreadsheet, format the print page output, print it.
But all these are manual steps.

I am trying to just look at a view page when I need, and share content when needed as a printed page (for people who have no access to systems).

To emphasise : it's the automation of viewing submitted forms.
Nextcloud workflow is limited (infantile IMHO for such an established office app).

[luckow]

@timconsidine It all depends on the details of the use case and the amount of data collected.

• Mautic Form -> submission overview as a table, viewable for mautic administrators/users
• Drupal Webform (https://www.drupal.org/project/webform) -> a complete universe of form workflows
• docuseal -> submission as a pdf for both: submitters & ducoseal admin/user (no aggregation of all submissions)
• https://form.io/ -> submission overview as a table, viewable for form.io users/admins
• typebot (build your own chatbot/botform) -> submission overview as a table, viewable for typebot users

[timconsidine]

@luckow you're entirely right

But I am looking for something lightweight.

I could not find one, so I built one :
https://forum.cloudron.io/post/78167

Hope it helps someone else.