def image_change(next): global count, reviewed, title_col if next: count += 1 image_link = sheet.cell(count, int( values_startup['-dlink_column-'])).value else: count -= 1 image_link = sheet.cell(count, int( values_startup['-dlink_column-'])).value existing = sheet.cell( count, int(col_schema.index('Reviewer') + int(starting_col) + 1)).value # Read and Update Title window.Read(timeout=2) window['-photo_title-'].update(sheet.cell(count, title_col).value) if len(str(existing)) > 0: reviewed = True else: reviewed = False try: webbrowser.open(image_link, new=0) write_response(bool_message=None, header='Reviewer', message=values_startup['-reviewer-']) except: sg.ErrorElement('Error') image_change(next=True)
def submit_changes(): subjects, languages = '', '' try: # Subject Submit for x in range(0, len(main_subjects) - 1): if bool(values[f'-{main_subjects[x]}-']): subjects += ', ' + str(main_subjects[x]) if bool(values['-subject_other_bool-']): subjects += ', ' + values['-subject_other-'] if len(subjects) > 2: subjects = subjects[1:] write_response(bool_message=None, header='Main Subject', message=subjects) # Language Submit for x in range(0, len(main_languages) - 1): if bool(values[f'-{main_languages[x]}-']): languages += ', ' + str(main_languages[x]) if bool(values['-language_other_bool-']): languages += ', ' + values['-language_other-'] if len(languages) > 2: languages = languages[1:] write_response(bool_message=None, header='Languages', message=languages) except: print('Submit Changes Error') sg.ErrorElement('Could not submit changes') if len(str(values['-post_comments-'])) > 1: try: # Comment Submit write_response(bool_message=None, header='Post Comments', message=str(values['-post_comments-'])) except: print('Could not post comments') sg.ErrorElement('Could not post comments')