Rx Note

Introduction Wistify.app is a mobile application developed by My Pharmacist House and its team. It allows users to seamlessly convert existing spreadsheets into functional mobile applications without writing any code. Currently, it offers three layout options: a searchable list, a quiz, and a decision flow. NOTE: On iOS, created apps can be accessed either directly as Progressive Web Apps (PWAs) via Safari or viewed within the official Wistify reader on App Store. Features Wistify. app follows a freemium model that includes a permanently free plan with basic, accessible features. The Free Basic package includes a limit of 3 published apps, a maximum of 1,800 data rows, and 1 GB of monthly storage. Upgrades are available when your application requires more capacity. Key features include Automatic database update notifications. Basic password protection for privacy. Notice board integration. File manager upload images and PDFs. Limitations Wistify exclusively supports CSV (comma-de...

Introduction After a deep dive into the programming world, I felt it was time to return to the familiar realm of medicine. I paused for a moment to reflect: with my current understanding of app development, how can I address some common needs of pharmacists? In the past, we often relied on no-code platforms like Open As App and AppSheet to convert spreadsheets into databases. While convenient, these platforms often came with limitations, specifically imperfect implementations and premium pricing. That is when the idea struck: what if we built a PWA that directly parses data from a public spreadsheet into a local IndexedDB? Thus, RxIDB was born. Importing A New Database Quick Steps Go to  Settings. Click Import New Database. Name your database and paste the public Google Sheet URL (make sure it is shared with "Anyone with the link can view"). If your spreadsheet includes introductory text or empty rows, you can adjust the header row number accordingly. You may also add an...

Introduction Caspio is a no-code platform designed to help businesses quickly build and deploy custom web applications without writing code. Although it specializes in database-driven application development, organizations requiring highly advanced features or extensive customization may find its capabilities limited. Plans However, Caspio’s existing Free Plan - which offers unlimited users and app usage with up to 50,000 data records - will end on October 1, 2025 . It will be replaced by a $100/month Lite Plan. Users can still trial a fully-featured account for 14 days, but all data will be deleted after the trial period unless the account is upgraded. Keyword Searching Across Multiple Fields To enable keyword searching across multiple fields, you need to create two DataPages; a Submission Form and a Report . The values from the first form will be passed to the second using virtual fields. Submission Form In the Select Fields page, move any available fields into the selected field...

Introduction Structured Query Language (SQL) empowers data analysts to communicate with their databases. While spreadsheets (e.g. Microsoft Excel and Google Sheets) offer data storage and management, databases excel at handling larger and more complex datasets. Popular SQL programs include MySQL , Microsoft SQL Server and BigQuery . SQL Statements Database actions are primarily performed using SQL statements, which consist of easy-to-understand keywords like: Database CREATE DATABASE - Creates a new database. BACKUP DATABASE - Creates a backup of an existing database DROP DATABASE - Deletes an existing database. Table CREATE TABLE - Creates a new table within a database. ALTER TABLE - Modifies an existing table. DROP TABLE - Deletes a table from a database. TRUNCATE TABLE - Delete the data inside a table, but not the table itself. Data SELECT - Extracts data from a database SELECT DISTINCT - Returns only distinct (different) values UPDATE - Updates existing data in a databa...