In this edition of the Alpha Software demo and Q&A webcast:

00:00:00 - Dave McCormick, VP of product management, discusses the upcoming Alpha Developers Day on November 9, 2023. This virtual event is free and will feature talks on Progressive Web Applications (PWAs). McCormick mentions increased progress on PWAs since their previous discussion two years ago and directs viewers to find release notes through a Google search for "Alpha Software release notes." He briefly touches on UX components like text boxes and date pickers before shifting the focus to the spreadsheet control. This control provides JSON formatted data similar to a spreadsheet. McCormick highlights two improvements: the ability to add columns dynamically with JavaScript and the capability to identify dirty rows for efficient data updates.

00:05:00 - The discussion continues with information about Alpha DevDay and the Spreadsheet Control component. The speaker demonstrates how to use the Spreadsheet Control by downloading it from the component library, adding columns, resizing the control, and converting data to formats like CSV and JSON. They also introduce the device assets feature in Alpha Transform for creating and accessing offline SQLite databases using the Spreadsheet View, CSV View, and Json View.

00:10:00 - The speaker shows how to save changes in the spreadsheet control and create a new CSV file name. They demonstrate uploading this data to an SQLite database and S3. A new feature for importing Excel data into SQL databases is highlighted, along with discussions about the Fire Store utilities and an upcoming update for Dev Day. The agenda and presenter details will be available about a week before the event, with recordings of all sessions. Attendees can participate in breakout sessions for direct interaction with programmers, and questions can be directed to guides at alphas software.com.