Como posso criar ou inserir tabelas de entrada de dados e calculo

Ola,

Estou tentando inserir nos meus formularios tabelas de calculo como uma planilha de excel, contendo celulas de entrada de dados e outras celulas contendo formulas para serem calculadas durante o preenchimento da tabela. A medida que se preenche uma coluna de dados a coluna seguinte ja calcula.

Voce pode orientar como possso inserir uma tabelas de 4 colunas e 12 linhas? Sendo que 2 colunas possuem células de calculo e as outras duas são celulas para entrada de dados.

Obrigado

Mario

Hi, I'm trying to insert calculation tables into my forms as an Excel spreadsheet, containing data entry cells and other cells containing formulas to be calculated when filling out the table. As you fill in a column of data, the next column is already calculated.

Can you advise how I can insert a table with 4 columns and 12 rows? Two columns have calculation cells and the other two are cells for data entry.

Thanks

Mario

Hi Mario,

Thanks for reaching out to Jotform Support. I'd like to let you know that I am using a translation tool to provide assistance, but if you would prefer to get assistance in Spanish Language, we can forward your ticket to our Spanish team. However, please note that it could take longer to receive a response.

With regard to your concern, give me some time to check this out. When I have an update, I'll let you know.

Hi Mario,

Thanks for your patience and I apologize for the delay. I found a solution. We can use the Input Table element and use Update/Calculate Field conditional logic. Let me show you how:

1. Click on Add Form Element
2. Select Input Table
3. Click on the Gear Icon
4. Select Field
5. Under Input type, select Numeric Texbox
6. Label the row and column. If you need to add more rows and columns, just simply add a new line

Now, let's create the condition.

1. Click on Settings
2. Select Condition
3. Select Update/Calculate Field
4. Create the Condition. Add a If statement. In this example, If Table is filled
5. Select Calculate Field Value for the Do
6. Create the Calculation
7. For the Summary, select the table and select the specific cell to where the result will show

When creating the calculation, make sure you know the formula and use the Add Field button to choose the table and the specific cells involve in the calculation as shown in the screencast below.

For the Speed, the formula is, Distance/Time.

Here's the demo form. I only created calculation for speed in row 1.

Give it a try and let us know if you need more help.

Thank you, I will follow your suggestion.