Use Adobe captivate as an interactive ticketing system?

Report · Sep 22, 2021

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.

Report · Sep 23, 2021

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

Report · Sep 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?

Report · Sep 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.