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”)