Skip to main content
D
defaultzyrklv6czk63
Participant
September 22, 2021
Question

Use Adobe captivate as an interactive ticketing system?

  • September 22, 2021
  • 1 reply
  • 316 views

Hello,

I have a special question, I have an experiment with Adobe Captivate and I would like to know if you can create commands with buttons so that a text example in Excel can be inserted in a specific cell.

I know that was a little stupid explained but here is an example:

You create an interactive button and when you click on this button then a text (which you have previously defined) should be added in Excel or Word.

What is the goal?

Well, we have created a ticket system at work with Excel macros and enter there always processes that repeat themselves over and over again. In order to speed up this process, I thought we could create a ticket system in which the buttons are simply clicked in a sequence and everything is automatically filled out in Excel with just a few clicks. Without that we must select a cell and there because certain text must write again and again.

With Javascript this should be possible with Adobe Captivate ? I know that Adobe Captivate is not actually intended for this but the functions are actually available only the question is how to connect the whole thing with Excel?

Thank you very much.

 

    This topic has been closed for replies.

    1 reply

    TLCMediaDesign
    TLCMediaDesign
    Inspiring
    September 23, 2021

    You could do this using Google Sheets. I use shhets in a project to record user quiz responses.

      D
      defaultzyrklv6czk63Author
      Participant
      September 23, 2021

      If it is possible then I would like to know how this works what exactly do I need to do and do I need to use javascript for this or rather just set conditions? would it also be sufficient to create buttons that trigger a macro in sheets?

      TLCMediaDesign
      TLCMediaDesign
      Inspiring
      September 24, 2021

      It's fairly complicated, but you need to set up the Google Sheet and get the API key.

       

      You then attach a JS file to your Captivate output or edit the CP template files. Put the API key in the JavaScript. You will need to trigger a JavaScript function with an enterslide or a button to get the CP variables and send them to the sheet. The Google Apps Script will need to be written to know what to do with the information. There is lots of documentqtion on the GAS, but not the CP part.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices