Hi there, I'm looking to use the sheets to allow a user to look up their data using their data. For example, steve@steve.com inputs his email and sees that he has completed X courses and earned X points. Each course and points total would be a different cell in the sheet. Is this possible? Thanks
Reply
Posted on 9/15/2022
Please type your reply.
@support
Steve, if you are good with Excel formulas and can figure out a formula for that - then, in theory, you can use SheetsSet to write a formula to a cell and then use SheetsGet to retrieve the calculated value.
Reply
Posted on 9/15/2022
@steve
Hmmm, interesting. I'll give that a try. Thanks.
Reply
Posted on 9/15/2022
@steve
Thank for the tip. I got it working, and it is awesome.
Reply
Posted on 9/19/2022
@support
Props for your formula writing skills! Not many people would be able to pull it off.
In the JavaScript trigger you will do: SheetsSet('Formula', '=VLOOKUP....'); SheetsGet('Formula', 'varname');
So you are writing a formula to a cell titled "Formula," the value gets calculated as you do it, and then you read the calculated result and save it to a Storyline variable "varname."
If you need more help, please consider starting a new thread so we don't spam Steve with all these messages.