Each time you create a new record or modify an existing one, Caspio Bridge can automatically attach many types of data to that record. This is a great way to instantly capture additional information that can help you better understanding your data and your app users. Examples include:
- Time stamp of when the record was added or modified
- URL of the host webpage
- User IP address
- Username and other user profile data
- Randomly generated passwords, IDs, GUID (Globally Unique Identifier), and other values
- Sequential auto numbers
This week’s Tech Tip, Automatically Stamp Records with Time and URL, takes a look at how you can apply timestamps (record the current date and time) and track the URL of the accessed DataPage, each time a record is added or modified. Because Caspio DataPages can be deployed to as many web pages on as many websites as you choose, this is a great way to see which web pages your app users are coming from. It is very easy to automate this type of information gathering, and both examples can provide valuable usage statistics about your web apps.
Recoding the Timestamp A timestamp instantly records the time and date of new submissions or data modifications. Since this process is automated, timestamps are much more accurate than asking users to enter this data themselves. If you haven’t added a timestamp to any of your DataPages yet, take a look at the Tech Tip to see how easy it is. Recording the Host URL Recording the web address where your DataPage is deployed provides a clear picture of how and where your apps are being used, which deployment is most popular, and what quality of submissions come from different pages. You can even choose if you want to record only the domain name or the entire URL. It only takes a few minutes to add this powerful functionality to your own DataPages. View the step-by-step instructions to try it for yourself, or contact Caspio Support and we’ll help you get started.
- - How to Create a Database from Excel (Part 1: Import Spreadsheet)
- - Form To Excel – Three ways to get web form data into Excel
- - Announcing Caspio Global Sites for Better Performance and Compliance
- - Need Structured Data in Your CMS? Embed Caspio’s Cloud Database
- - Convert Microsoft Excel to a Web Database
TagsAmazon app templates awards BYOD Caspio Cloud Cloud Apps cloud computing cloud database community customers database reports data sets election Excel extensions facebook government how-to iPad iPhone Map Mashup media mobile mobile apps MS Access MS Excel News non-profit online database paas plugins ready-made applications ready-to-publish database roadmap searchable database search applications security Services usability web applications web apps web design web forms widgets