Skip to main content

Posts

LSL - Vendor Script with Google Docs Tracking

Better late than never I suppose.  Last post, like 2 years ago, I talked about how to set up a Google Form to track data in a Google Sheet for use in LSL scripts.  It's very similar to how you would make a GET call in a PHP web form.  Anyway, I'm here to post a Vendor Script that is designed to work with the Google set up to track sales.  The form values you want to create in the Google Form are: Avatar, Location, Price, and Item. The script is available below, you can also have one delivered through the Marketplace .  I have used this vendor script in world but I didn't build the base Vendor functionality, so I would test it out with a cheap price and a friend or an alt to make sure it's working properly.  I take no responsibility if this screws up and you lose L$.  This script should be placed in the root prim of a vendor along with an informational Notecard of some kind, and a single item to be distributed on payment.  You'll need to box ...

Setting up a Google Docs Form for Second Life Interaction

I'm using Google Docs now with Second Life for tracking a few different things, and the basic set up is the same, so I've decided to just make this it's own post, that I can reference later.  For this example, I'm using aspects of the sales tracker script, but it can be adapted for any script. Google Forms can be easily used to track various inworld activities in Second Life.  I am currently using it to track visitors to my store and for tracking sales in my store.  It's free, it doesn't require running or setting up a webserver or PHP or SQL.  I will say up front, I have no idea if there are API limits at all to this.  My use is extremely low traffic.  I suspect that, since it's Google, it's pretty robust. Firstly, go to your google drive, at drive.google.com .  Create a new form and name it something useful.  In this case, I used "Gique Sales Tracker". Change the default included field to "Short Answer" and give it a usef...