I am setting up a VA command for Elite with a plug that can read a google document spreadsheet.
Right now I have a two part prefix/suffix command so I can say something like:
"Where can I find" "Antimony"
Right now the suffix command has two separate lines for each item.
Else If Text Compare : [{SUFFIX}] Equals 'Antimony'
Set Text [Row] to '5'
What I realized yesterday is I can set the row to be a variable instead so I created this read it out when you give it the correct {Row} varable
Else If Text Compare : [{SUFFIX}] Equals '{TXT:SheetRange{TXT:Row}Col0}'
My question for this now is, the way it stands, I have 2 lines per item in the code, but each item is also in the 0 column of the spreadsheet.
Is there perhaps a way for me to have a loop where it checks the {TXT:SheetRangeRow{TXT:Row}Col0} line on the spreadsheet, if it does not match add 1 to Row and loop again.
If the text matches what the suffix command was, exit loop and continue with the script.
It would exit the loop if it matches what was said, or it hits the end. I plan on putting something at the end of the spreadsheet like "NO MORE DATA" so if it sees that it will stop and not just continue down an empty spreadsheet looking for items.
I can visualize it in my head on what it needs to do, but I am one of those people that once I see an example it clicks.. as of yet I have not been able to get this to click yet and am struggling with it.