Getting started

Page 1Page 2

Hi, Can you help me set up one or two variables in my project so I can get going ... I don't seem to be able to make it work?

August 17, 2021, 6:43 pm

Click for thumbs down.0Click for thumbs up.0#1

Dean, what is your question?

August 17, 2021, 8:23 pm

Click for thumbs down.0Click for thumbs up.0#2

Hi John,

I am struggling to get it all working ... if I sent my file could you add one or two variables to it so they add to my Google sheets?

August 17, 2021, 8:41 pm

Click for thumbs down.0Click for thumbs up.0#3

We can try. Feel free to post a link to your file in the response below.

August 17, 2021, 8:43 pm

Click for thumbs down.0Click for thumbs up.0#4

Can I share privately?

August 17, 2021, 9:03 pm

Click for thumbs down.0Click for thumbs up.0#5

Are you there?
Here's my file .... can you set up Postcode to be collected to sheets as an example?

August 18, 2021, 7:19 am

Click for thumbs down.0Click for thumbs up.0#6

You should post just one slide you're having an issue with. I really have no need to see your entire project.

August 18, 2021, 8:32 am

Click for thumbs down.0Click for thumbs up.0#7

Here is a short version .. can you help as soon as possible .. I have been trying for weeks to get it working.

https://we.tl/t-fe5bxZ2XBF

August 18, 2021, 5:39 pm

Click for thumbs down.0Click for thumbs up.0#8

Dean, what is it that you're trying to do? Save the post code to Google Sheets?

August 18, 2021, 5:50 pm

Click for thumbs down.0Click for thumbs up.0#9

Yes, I have many other questions to capture but If you can help me with one I can get the others going

August 18, 2021, 5:57 pm

Click for thumbs down.0Click for thumbs up.0#10

I can share my sheet also if you need?

August 18, 2021, 5:58 pm

Click for thumbs down.0Click for thumbs up.0#11

Thanks so much for the help...

August 18, 2021, 5:58 pm

Click for thumbs down.0Click for thumbs up.0#12

Would you like to share an email address so I can share the sheet I have set up?

August 18, 2021, 6:04 pm

Click for thumbs down.0Click for thumbs up.0#13

Ok, you need to add the following trigger to execute when the variable Postcode changes:

var player = GetPlayer();

SheetsSet('Postcode',player.GetVar('Postcode'));

August 18, 2021, 6:12 pm

Click for thumbs down.0Click for thumbs up.0#14

I have added that on screen 1.2 ... did I do it correctly?

August 18, 2021, 6:14 pm

Click for thumbs down.0Click for thumbs up.0#15

I can see data in the sheet 🙂

August 18, 2021, 6:20 pm

Click for thumbs down.0Click for thumbs up.0#16

Oh, I see your trigger now, on the Next button, correct? Yes, it looks good. I would just double-check the order of the triggers. Currently, jump to next slide is placed before the SheetsSet trigger. The latter will never execute because you're leaving the slide before it gets to that trigger.

August 18, 2021, 6:25 pm

Click for thumbs down.0Click for thumbs up.0#17

What would be the best trigger?

August 18, 2021, 6:27 pm

Click for thumbs down.0Click for thumbs up.0#18

The way you have them is fine, just change the order so that jump to next slide occurs after the other two.

August 18, 2021, 6:31 pm

Click for thumbs down.0Click for thumbs up.0#19

OK ... let me test

August 18, 2021, 6:43 pm

Click for thumbs down.0Click for thumbs up.0#20

Page 1Page 2