Hi.i dont know how the hymn books are readable in your pc so my best bet would be to create something like a "middleman" that will read the info that book creates and then point data source to permanent read this info and pass it to vmix title.a script,a python external script,something like this.
What AI gpt says after i send your case and it after some time
Of "thinking" says
Solution 1 — Single-row “NOW” sheet lookup (no row switching)
Idea: Keep one master list, and one tiny “NOW” sheet with a single live row. vMix binds to that one row only. The operator types Book + Page, and a lookup formula returns the Title; the lower third updates automatically.
How to set it up
• In your master sheet (tab DATA) keep columns: Book | Page | Title | Key.
In Key use: =Book&":"&Page (e.g., A:301).
• In a second tab (NOW), make input cells for the operator:
• A2 = Book (A or B)
• B2 = Page (number)
• C2 = Key → =A2&":"&B2
• D2 = Title
• Lookup the title in DATA using the key:
• Excel (XLOOKUP): =XLOOKUP(C2, DATA!D:D, DATA!C:C, "Not found")
• Excel/Sheets (INDEX/MATCH): =INDEX(DATA!C:C, MATCH(C2, DATA!D:D, 0))
• In vMix → Data Sources, point your title to the NOW tab and map fields (Book/Page/Title) from that single row (e.g., row 2). You never change rows during the show.
Operator flow: Type Book and Page → the Title cell fills → lower third updates. No 300-row juggling, no source switching.
Solution 2 — vMix UTC mini-panel with search (operator-friendly)
Idea: Use vMix UTC (Universal Title Controller) to load your full hymn list and give the operator a searchable list. They type part of the page number or title, hit Enter, and UTC pushes the text to your lower third.
How to set it up
• Export your master list to CSV (or use a published Google Sheet).
• In vMix UTC:
• Set the vMix connection (IP/port).
• Add a List/Table widget bound to your CSV/Sheet.
• Add a Search box / filter so the operator can type 301 or a word from the title.
• On row select (double-click or a “Send” button), configure actions to SetText on your GT title fields (e.g., Title, Book, Page) for the target input.
• Optional: show both hymn books in one list with a Book column, or make two tabs/lists and keep a single search field.
Operator flow: Start typing → filtered list → select → lower third fills instantly. No row limits, no data-source swapping inside vMix.
Why these feel smoother:
• #1 keeps vMix fixed on one data row; the operator only changes two cells.
• #2 gives a fast, searchable picker built for live use, ideal when you don’t know the songs in advance.
Both solutions seem to me to be real and not "illussions" that's why i post them.