The community member is asking if there is a way to access saved variables from within a bot, in order to check for duplicate redemption codes before storing them in an external database. They want to be able to query the bot for codes that have been created but not yet added to the database, to avoid duplicates. In the comments, the community member mentions that they no longer need this functionality as they are using a different solution (nocoDB) that is faster and avoids the issues they were facing with using sheets. However, they are still curious if there is a way to access the table/array of generated codes from within the bot itself.
Is there a way to access these saved variables from within the bot?
I want to just check them for duplicates to see if a redemption code has been issued before (Also storing them in an external database)
I would only need to query like the last minute or less (but open to querying more depending on posibilities). Once a code is generated and no duplicates are found, I do store it in the database as a used code so I just need to query the bot for codes created but haven't made it to the database yet.
I don't need this anymore- nocoDB is so fast that I just check and post the ID there. There was a delay with sheets to the point that simultaneous use was a real concern.
BUT, my question was more- if it does get saved in the results table- would there be a way to access it in the bot-
Like if it were a list of IDs, could I check them with a loop for duplicates.
{{={{myIDs}}{{[iDiterator]}}=}} isEqual {{newID}}
{{={{iDiterator}}+1=}}
and loop that for no true results...
But like I said I don't need this right now, just wondering if there is a way to access that table/array from within the bot itself.
