Form with calculated and lookup value

  • Resolved misterngan

    (@misterngan)


    10 months, 1 week ago

    Hi,

    I am trying to move my booking system from a spreadsheet to a WordPress site with WP Data Access. I want to create a form to collect some data. Can I have the form calculate the number of days base on two column with starting date and ending date. I also want the form look up a the price from a price table. Is it possible?

    Thank you

    Peter

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi Peter,

    Thanks for the post.

    Can I have the form calculate the number of days base on two column with starting date and ending date.

    Is the result (number of days) stored in another column in the same table? Data Forms in WP Data Access is just a form version of the INSERT query in SQL. Computed columns are generally suggested for views instead of tables. At the moment, this cannot be done with our plugin. ??

    ?I also want the form look up a the price from a price table. Is it possible?

    This is possible using relationships. You need to create a data project and set up a relationship between the two tables. The steps to set it up relationships are outlined here: One-To-Many relationships | WP Data Access and Many-To-Many relationships | WP Data Access

    Let us know if that helps. ??

    Thread Starter misterngan

    (@misterngan)

    Thank you very much.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Form with calculated and lookup value’ is closed to new replies.