Missing something getting form data to save to supabase

no idea what I’m doing but its definitely wrong.

import streamlit as st
import pandas as pd
import numpy as np
from st_supabase_connection import SupabaseConnection, execute_query

conn = st.connection(
name=“”,
type=,
ttl=None,

with st.form(key=“Registration form”):
Ticket = st.text_input(‘Ticket’)
Schedule_Notes = st.text_input(‘Scheduled Notes’)
Pulled_Week = st.text_input(‘Pulled Week’)
Service_now_status = st.text_input(‘Service_now_status’)
Specialist_Name = st.text_input(‘Specialist Name’)
REQ_Number = st.text_input(‘REQ Number’)
PO_Number = st.text_input(‘PO#’)
Warranty_Status = st.text_input(‘TWarranty Status’)
Cost_Center_x5_0400 = st.text_input(‘Cost Center(#x5-0400)’)
FacName = st.text_input(‘FacName’)
Address = st.text_input(‘Address’)
City = st.text_input(‘City’)
State = st.text_input(‘State’)
Zip_Code = st.text_input(‘TZip Code’)
submit_button = st.form_submit_button(label=‘Data Entered’)

def addInfo(a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z):
addInfo(Schedule_Notes,Pulled_Week,Service_now_status,Specialist_Name,REQ_Number,PO_Number,Warranty_Status,Cost_Center_x5_0400,FacName,Address,City,State,Zip_Code,Point_of_Contact,Email,Phone_Number,Weeknumber_read_only,Coupa_Closure,Ticket_Type,Billing_Week_Read_Only,Scheduled_Date,Snow_Closure)
rows.execute()
rows.execute(“INSERT INTO registration values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)”, (a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z))
conn.commit()
conn.close()
st.success(“Data inserted correctly”)

This is not the query syntax supported by Supabase or st_supabase_connection.
Have you followed the README?

>>> execute_query(
        st_supabase_client.table("countries").insert(
            [{"name": "Wakanda", "iso2": "WK"}, {"name": "Wadiya", "iso2": "WD"}], count="None"
        ),
        ttl=0,
    )
    
APIResponse(
    data=[
        {
            "id": 250,
            "name": "Wakanda",
            "iso2": "WK",
            "iso3": None,
            "local_name": None,
            "continent": None,
        },
        {
            "id": 251,
            "name": "Wadiya",
            "iso2": "WD",
            "iso3": None,
            "local_name": None,
            "continent": None,
        },
    ],
    count=None,
)

Are you talking about this?

And do I somehow attach it to the submit button?

>>> execute_query(
        st_supabase_client.table("countries").insert(
            [{"name": "Wakanda", "iso2": "WK"}, {"name": "Wadiya", "iso2": "WD"}], count="None"
        ),
        ttl=0,
    )
    
APIResponse(
    data=[
        {
            "id": 250,
            "name": "Wakanda",
            "iso2": "WK",
            "iso3": None,
            "local_name": None,
            "continent": None,
        },
        {
            "id": 251,
            "name": "Wadiya",
            "iso2": "WD",
            "iso3": None,
            "local_name": None,
            "continent": None,
        },
    ],
    count=None,
)

Are you talking about this?

Yes, and yes