Step 5: configuring the Excel workbook for subscriptions

1.In your XLS Padlock project, navigate to the “Activation Keys / Online Activation” page.

In the Base Activation URL field, enter the base URL as defined previously (see Base URL for activation) on your web server followed by /getsubactivation/{product-path} (a final slash / is not mandatory) and replace {product-path} with the product path associated to your workbook (and defined in workbooks.json).

In our case started earlier, it would be:

https://www.mywebsite.com/subscription/getsubactivation/markbook-demo

If the product path is omitted, the first product defined in workbooks.json will be used.

XLS Padlock can handle TLS/SSL connections: if your web server has a valid SSL certificate, you can use secure URLs that begin with HTTPS.

2.Click Registration Form Editor. XLS Padlock shows a basic HTML editor and a preview of the dialog’s text. You can define your own HTML text but at least an HTML field named token is required.

To identify the subscription of your customer, the web application expects the compiled workbook EXE to send a unique order identifier called token. For your customers, it’s an activation code but internally we will name it the “token”.

For instance, we can use the following HTML code for the registration form editor:

Activation Required

Welcome to this sample application made with Excel and XLS Padlock. <A

href="https://demo.xlspadlock.com">Learn more about this application</A> To access this application, please enter

the activation code that you received after your order and press Activate. If your computer has no Internet connection,

choose Manual Activation.

Your Activation Code: <CONTROL TYPE="EDIT" WIDTH="280" VALUE="" ID="token">

Only this part is mandatory because it defines the HTML field that lets the user enter his activation token:

Save your changes and close the editor.

3.Compile your workbook EXE application. It is now associated to the web application and ready for testing!

Step 6: let FastSpring generate activation tokens and send them to customers