Forminator Calculations, read formula from Database

  • Resolved realasim

    (@realasim)


    1 year, 7 months ago

    I wanna create a Quotation generator that would update estimated total price as options of services are checked on a list of check boxes

    The cost of services can change and I would like to create a second page where administrators can add services or change cost of services, my first guess was using mysql to store services values and their costs, open to using any storage mechanism if it allows me to store those,

    How can I read fields from services from a database if possible or just change the calculation factor based on stored cost in database?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @realasim

    I hope you are doing well today.

    If you use checkboxes and based on those price is calculated you can use BULK EDIT mode and import your data from CSV file in correct format which is available to download in BULK EDIT mode.

    With that, you can simply keep your CSV file on PC, and whenever prices will change, simply update your file and then upload your file again to that checkbox filed and update form. With those simple moves you will be able to update prices in form.

    One question appear now, does all prices change from time to time on same date or only 1 price from time to time on different dates? If there is multiple prices like over 100, this could be anoying with above workflow and maybe we could suggest some solution with help of our SLS team. Note if task will be to complex it take be out of scope of our support.

    https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#checkbox-bulk-edit

    Kind Regards,
    Kris

    Thread Starter realasim

    (@realasim)

    Hi, Thanks for getting back to me,

    Issue here is I am being pushed to make it as simple as possible as I wont be around to change the estimated prices of services after I am done with the project and the person supposed to change those is not very good at tech so a simple password protected page with an input and a button to update the price is my purposed solution

    I can code both estimator and updater from scratch but I didn’t feel good about not having an option to read/write custom values from database and I think Forminator should have said functionality, let me know if I can help with one

    Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi again @realasim

    Taking into account data you have shared it seems to be more complex and out of scope. In short only proper solution will be to teach that 3rd party person on how to update CSV file, which is sheet in general and how to bulk update that in checkbox field based on above guide shared in previous reply.

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @realasim ,

    We haven’t heard from you for a week now, so it looks like you don’t have more questions for us.

    Feel free to re-open this ticket if needed.

    Kind regards
    Kasia

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Forminator Calculations, read formula from Database’ is closed to new replies.

Tags