So I scrapped everything that I did beforehand and figured I can check to see if user’s email matches a record in the company_info data table and if it does pull the data and assign it to the textbox.text fields.
I now getting this error
TypeError: ‘NoneType’ does not support indexing at [admin_haga_system, line 43]
Line 43 is company_info[‘Company_Name’] = self.company_name_textbox.text
if app_tables.company_info.search(Email=anvil.users.get_user()['email']):
company_info = app_tables.company_info.get(Email=anvil.users.get_user()['email'])
company_info['Company_Name'] = self.company_name_textbox.text
company_info['Address'] = self.company_address_textbox.text
company_info['Admin'] = self.admin_textbox.text
company_info['Email'] = self.email_textbox.text
company_info['Phone_Number'] = self.phone_number_textbox.text
company_info['Company_Representatives'] = self.company_reps_textbox.text
else:
alert("User does not have company profile. Please contact Admin")