Customer forms on front-end.

Hi @stonefunk,

Thank you for your kind words! ??

I am about to release a new product feature which can help you to create responsive database applications without any programming. I hope to have a demo live this week. Please allow me to come back to you when the demo is online…

Best regards,
Peter

That sounds fine.
Looking forward to it ??

Best Regards
/Svante (stonefunk)

Hi Svante,

The demo is online. You can find it here:
https://wpdataaccess.com/docs/documentation/data-forms/project-demo/

The new feature will be available in the next release.

Let me know if you have any questions.

Best regards,
Peter

Its a fantastic plugin, no doupt about that. ??

This is however not what i ment by “form” in my comment. To fill the gap from customer –> database –> customer i need a nice looking form like Caldera Forms or simular. A Form to collect data from customer, process the data and then again present the data on the front end. Caldera Forms does just that but there is no easy way to manipulate the data in a nice SQL-matter. MySql sample “SELECT * FROM movies WHERE category_id = 2 AND year_released = 2008;”

Your plugin does just that manupulation of the data but on the other hand missing out of the data front end collect part. I am probably wrong and if so correct me please.

Sorry to show this on your supportpage but its the easies way to explane. I remove it if you want directly offcource. Caldera Forms

The abolute perfect world i could grab a value from the database and put it into the front end formfield with a “magic tag” or whatever method you prefer. If so i belive your plugin would become a smash hit. ?? I′ve looked a long time on the internet to find a booking plugin that i can use with no luck. Your plugin is the closest yet to my goal.

The submitted data could then affect the choices when the next customer fills in the same form. With some sql arguments the values in the form becomes dynamic.

Best Regards
/Svante

• This reply was modified 4 years, 3 months ago by stonefunk.

Hi Svante,

You might be able to use WP Data Access for your purpose, but the plugin follows a different philosophie than Caldera Forms. You can add columns to your forms from Data Projects > Manage Table Options. Here are some tutorials :
https://wpdataaccess.com/docs/documentation/data-projects/manage-table-options/
https://wpdataaccess.com/docs/documentation/data-projects/table-options-advanced/

This basically works the same as the “magic tags”. ?? You can:
– add the columns you want to be displayed
– hide columns you don’t want be displayed
– change to order in which columns are shown
– change column labels
– use formats (dates, numbers, textareas, and more)
– add listboxes (single and multiple)
– and more

You can also style your data entry forms. This page might be helpful for styling:
https://wpdataaccess.com/docs/documentation/data-projects/styling-a-project-page/

The tutorials are a bit outdated, but the features shown still work the same way.

Hope this helps! ??

Best regards,
Peter

Hej Peter.

The plugin is a bit complex but i work my way thrue it. I managed to make some form on the front end. Made 2 lookup dropdowns in the booking form. The only thing left is to have a functioning booking form for the boat club is the WHERE Clause with a special action.

What is best practice for making the second dropdown only show the next avalable post in order. The table sublift_date contains the 12 dates the harbour service is available and next collumn the number of timeslots that day. The table sublift_time contains only 8 timeslots like 08:00-08-45, 08:45-09:30,,, and so on. The plan is when a customer choose a date only the first available timeslot vill show in sublift_time dropdown.

Is Subquery the way to go or how do you think works out the best in your plugin?

There is 3 tables.
sublift_bookings: all booking data like id, name, boatname, date, time,,,, and more
sublift_date: 3 columns – id, date, number of timeslots per/day
sublift_time: 2 columns – id, timeslots

sublift_date and _time is for self service by the personal. They should fix the dates themself in the front end form (already done an functioning)

sublift-booking is for booking the service for customers. (already done with exeption of the action descriped above).

The last thing is css. I deal with that later on…

Best Ragards
/Svante

Sorry for my poor english spelling…

Hi Svante,

Interesting use case! ??

>>> What is best practice for making the second dropdown only show the next avalable post in order.

You will need to add some logic to your lookup, which can be achieved with a view. You have to write a view which gives you the next available timeslot(s) and use that view in your lookup. Is there someone in your team with sql experience who can write that view?

Please be aware that your view will use the DBMS time, which does not necessarily need to be the same as the time in the browser of your visitor.

Best regards,
Peter

Thank’s Peter,

Yes there is. This is a project on my spare time but i work like a IT-Servicedesk and can ask the SQL-people.

Now i know it′s possible and going to give WP data Access a bit more attention. I am a Graphic Designer with some skills in programming but not a specialist in any way. A so called Google-programmer ??

Regards
/Svante