Not saving data in Google Drive

Anvil Q&A
1

Hi, Im making a survey. I put that survey in a custom domain, but is not savings the results. In fact is impossible to finish it because of it

This is the code that i use to save the answers

from ._anvil_designer import descriptivaTemplate
from anvil import *
import anvil.tables as tables
import anvil.tables.query as q
from anvil.tables import app_tables
import anvil.server
import anvil.google.auth, anvil.google.drive
from anvil.google.drive import app_files

class descriptiva(descriptivaTemplate):
  def __init__(self, respons, **properties):
    # Set Form properties and Data Bindings.
    self.init_components(**properties)

    # Any code you write here will run when the form opens.
    self.primal.text=respons
  def button_1_click(self, **event_args):
    respons=self.primal.text
    for radio in self.d1.get_components():
      if radio.selected:
        q1=int(radio.value)
      q2=int(self.edad.text)
    for radio in self.d3.get_components():
      if radio.selected:
        q3=int(radio.value)

    
    respons[55]=q1
    respons[56]=q2
    respons[57]=q3

    print(respons)
    
  
    f = app_files.tesis
    ws=f['resultados']
    row=ws.add_row(block=respons[0], 
                   acepto=respons[1],
                   f_literacy1=respons[2],
                   f_literacy2=respons[3],
                   f_literacy3=respons[4],
                   f_literacy4=respons[5],
                   f_literacy5=respons[6],
                   f_literacy6=respons[7],
                   f_k1=respons[8],
                   f_k2=respons[9],
                   f_k3=respons[10],
                   f_k4=respons[11],
                   f_k5=respons[12],
                   f_k6=respons[13],
                   f_k7=respons[14],
                   f_k8=respons[15],
                   f_k9=respons[16],
                   f_k10=respons[17],
                   f_k11=respons[18],
            
                   investment6=respons[69],
                   correo=respons[70])
    open_form('Final')

The debug version is working fine, and this is only a sample of the code i erase part of it because it only contains more questions and the later respons to save them

2

What happens if you add a print(ws) after these lines?

As a side note, the formatting on your post is bad because you added 4 “´” instead of 3 “`” (forward leaning instead of backwards leaning).

As a side side note, do you have a table with 70 columns?
It’s often easier to put al the info in a json object and store it in a simple object column. I only use dedicated columns for data used for searching and sorting, and one or two simple object columns for all the other data.