Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to add a simple calculated field to a google form?

I'm looking for a way to add simple calculated field in a google form that will be dependent on other field's values.

The first field is a simple price field quantity * price = total_price where quantity is a numeric field entered by the user.

The second field is an end date now() + X months where X is selected by the user.

I'v taken a look at google's tutorials and found only addons which in my understanding are form wide where i'm looking for something more like a custom form field.

The best solution would be one that would calculate the fields as the user change the other input's value but a simple text in the confirmation page is also OK.

I would appreciate if anyone could point me in the right direction. Thanks.

like image 990
haki Avatar asked Apr 13 '15 08:04

haki


1 Answers

As others mentioned, Google Forms does not support calculating values in realtime. However, there are 2 Google Forms addons that let you do that (Disclaimer: I created them):

  1. For simple expressions like the ones you mentioned (quantity * price = total_price) you can use Formfacade addon - https://formfacade.com/website/google-forms-calculated-fields.html
  2. For sophisticated order forms with order total, delivery fee and order summary, you can use Neartail addon - https://formfacade.com/neartail/automatically-calculate-total-amount-in-order-form.html
like image 154
Réti Opening Avatar answered Oct 22 '22 03:10

Réti Opening