Tables | Google Sheets

Here's the English translation:

"I have a question about tables; in a 'Jotform' table I want to bring a value from a Google Sheets cell, so that this value can then be multiplied by another value within the same table so that another cell generates the result of the multiplication. Is it possible to do this? And how would it be done if it's possible?

Basically what I want to do is have that table published on the web to show service rates, that is, costs, and for this, the costs are in one currency and must be displayed in the country's currency, which is why I want to 'bring' that value from Google Sheets to the table.

Note: I already have the Google Sheets ready that brings me the Euro value in my currency, which takes it from the government bank where it shows the official currency in real time. I have the spreadsheet public, and the access data, the URL and any other data that might be needed.

Hi Agustin,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your question, Jotform Tables allow you to create Advanced Formula columns where you can perform calculations like multiplication between values within the same table. However, directly bringing a live value from a Google Sheets cell into a Jotform Table for use in formulas is not supported.

What you can do is integrate your form with Google Sheets to send form data there, but changes in Google Sheets won't update your Jotform Table automatically. To achieve your goal of showing service rates converted to different currencies, you might need to manually import or update the exchange rate values into a Jotform Table column and then use an Advanced Formula column to multiply those rates by your service costs.

Here’s how to use Advanced Formula in Jotform Tables:

1. Add a new column in your Jotform Table and select Advanced Formula as the column type.
2. Name the column and create a formula to multiply your cost value by the exchange rate value in another column.
3. Save the formula and the column will display the calculated results.

This way, you can publish the table on the web showing your service rates converted to the desired currency.

Give it a try and let us know how it goes.

"Manually would work for me, and could it be done from the table published on the web or from the control panel

Hi Agustin,

You can only manually update values from the Jotform Tables control panel, not from the table published on the web. Inline editing and submission updates are done within the control panel interface.

Let us know if you need more details.