Input Table: How to calculate number of filled rows

  • rabinlai
    Asked on March 26, 2019 at 4:52 PM

    I have 3 related questions:

    1) How can I total up the number of filled rows in a table? I need to collect reservations (i.e. sell tickets) for an event, each of which has the same cost. My form has a table where the person fills in their name and the names of everyone in their party and whether they are a member or a guest. At present I have a separate field where I ask them to enter the total number of reservations required (i.e. the total number of completed rows in the table). I just want a simple math function to count these rows (like =COUNTA() in Excel) and display the TOTAL automatically.

    2) Which of the many PayPal options would you recommend for me? I have a PayPal business account and would like to keep it simple for the customer filling out the form. Also, I cannot do difficult programming. There is only 1 variable: quantity. The reservation cost is fixed.

    3) And is there a way the PayPal quantity field can be automatically imported from the TOTAL field above?

    Thanks.

  • Mike
    Replied on March 26, 2019 at 6:51 PM

    1) Unfortunately, this is not currently possible to get a number of filled rows of the Input Table field. I have escalated a feature request ticket on your behalf, but there is no ETA for when it will be addressed. We will let you know if we have any updates on this.

    2) I would like to suggest a PayPal Standard integration or a PayPal Checkout integration.

    The PayPal Standard is easiest to configure. When the PayPal Standard is used, the form user is redirected to the PayPal upon the form submission.

    When the PayPal Checkout is used, the PayPal payment is being authorized in a pop-up window and processed upon submission.

    3) This is not possible to pass quantity, but you can pass the total amount if you use a User Defined Amount payment type. Please follow the next link for more information:

    How to Pass a Calculation to a Payment Field