Question:
I am getting quite frustrated w/Wix (either that or my knowledge). I cannot (code free) create automations on collections so I am using Forms and Submission Tables vs. CMS collections and custom fields on a page or light box. However, I am not seeing a code-free means of showing Submission data in a repeater for example. So it seems like my choice is 1) use CMS and custom forms and be SOL on automations or 2) use a Form and Submission table and be unable to display data in a repeater (or do anything w/the data like CMS can do).
Product:
Editor X
What are you trying to achieve:
Having a form that w/o code and trigger automations AND be able to manage and display the data in all the ways CMS allows.
What have you already tried:
Seemingly everything
Additional information:
Please help!
Anything collected via the native Wix Forms gets saved in it’s own database.
Any database can be connected to a repeater (unless for whatever reason Wix decided to change this, but I haven’t seen this change.)
You should be able to select any database via the dataset settings when connecting a repeater.
Again, I am pretty sure Wix has not changed this but I usually work with custom databases not the ones pre-made by Wix via Wix Forms. I am assuming Wix treats them the same as the databases for Wix Stores, Wix Bookings, etc, as those are pre-made by Wix as well (and we can connect those to repeaters and whatnot).
You just have to check the database permissions to see who can see what, etc. The settings can be accessed via the editor under Dev Mode.
Also, if you post screenshots along with your questions it will help the community understand what you currently have so we can pinpoint a problem a bit easier. At this point, my advice above is sort of a shot in the dark hoping I understood what you were trying to ask. So i hope my advice is somewhat accurate to lead you in the right direction.
I am unable to select a forms submission table from a dataset settings screen - sorry if that was not clear. Also if I go into Dev Mode and look at permissions on the database only Admin can view and the settings are not changeable.
Oh that is devastating. That limits the use of Wix Forms so much more.
I don’t know which automations you need, but if you use a Form dataset instead of a regular dataset you should be able to configure Wix Automations with it.
Or if you need extra help feel free to look me up on the Marketplace: Code Queen - Wix Marketplace
There is no wix automation that I know of that has a new record added to a database as a trigger (without code).
I am a not for profit org with no revenue so am trying to sort this out without spending $. www.setfire.com.
When a custom form is filled out, that is basically a new record that gets added to the database. That is a submission. You can set up a trigger via Wix Automations. You just have to use the Form Dataset instead of the regular Dataset so that Wix Automations knows you set up a custom form.
I want to sincerely thank you for taking the time to reply a few times. You solve something I have been beating my head against the wall about for 3+ weeks. Even Wix support told me that you cannot create forms attached to custom CMS databases (only Wix Forms databases). I did what you said and it works and I see the form now in automations as trigger. Thank you so much!
1 Like
