Wistify.app
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-delimited) data and Google Sheet URLs.
File Conversions
- Users must manually save Excel files in CSV format prior to importing.
- Because CSV files consist of plain text, all original Excel styling - including font styles, colors, cell borders, and conditional formatting - will be stripped during conversion.
- The sync URL must originate from a native Google Sheet rather than an uploaded Microsoft Excel file (identifiable by a .xls or .xlsx extension in Google Drive).
- The sheet’s sharing settings must be set to "Anyone with the link can view," or view access must be granted directly to wistify-gsheet@wistify-1aa9d.iam.gserviceaccount.com.
- Real-time, automatic data synchronization with Google Sheets is not supported. To pull updated information, creators must manually trigger the sync process (Manage Google Sheet > Preview Sheet) and republish the database within the Wistify dashboard.
- While automatic type-checking exists (e.g., verifying that header rows are not empty and contain no duplicate names), special characters (such as $, #, [, ], /, or .) are automatically removed.
- Hard restrictions apply even to the Pro plan: a maximum of 5,000 rows per app, up to 40 fields, 60-character field names, and 5,000 characters per cell.
UI & Functionality Constraints
- For searchable lists, the app provides a basic, uniform data display template.
- Headers remain visible on the user interface even if the corresponding data fields are blank (which are displayed as a hyper-dash, -).
- The platform currently lacks support for multi-page architecture, interactive calculations, embedded clickable URLs, and advanced user-interaction elements.
Security Constraints
- The platform relies on client-side access controls.
- While the password screen prevents casual browsing, it should not be treated as a high-security boundary.
- Avoid uploading high-risk or confidential assets, as front-end locks cannot completely obfuscate underlying application data from tech-savvy users.
Summary
Whilethe Wistify.app user interface is significantly enhanced, several technical design flaws remain to be fixed - such as the inability to delete draft apps or unpublish existing ones.
Because the application utilizes client-side access controls rather than robust server-side security, password protection only acts as a basic barrier against casual browsing.- Granting access via wistify-gsheet@wistify-1aa9d.iam.gserviceaccount.com allows you to avoid making your Google Sheet publicly accessible, but the platform remains unsuitable for private or confidential data.
- Wistify should only be used for public or low-risk information.

Hello, I've recently taken over the portfolio of maintaining our hospital formulary app made using Wistify. Previously the creator has synced the google sheet to Wistify and there were no problems displaying and updating. However, now despite pasting the URL to manually sync, the button will still remain as 'start sync' after loading. I tried closing the pop-up window and tried to save and publish, but was not able to. Would you happen to know to circumvent this issue? Thanks so much!
ReplyDeleteThe first step is to make sure the URL link is shared from a Google Sheet, NOT an Excel file (which may be titled with a ".xls" extension in Google Drive). If the file is already in Google Sheet, then may download the spreadsheet as .csv file and manually upload the file to detect any further issues.
DeleteThank you for replying!
DeleteI did copy the URL link from a Google Sheet, so that didn't work.
I downloaded as .csv file and uploaded it without doing any edits. The existing data immediately went blank and was replaced by the words 'An error occurred.', along with 3 pop ups on the bottom right screen corner:
'Overwrite data, kindly proceed with Apps Design Tab after save'
'No id field detected, Creating id field'
'Difference column detected, kindly remap your application'
The upper right screen corner now has an orange button 'Setup Apps Design'. Not sure if I should proceed as I fear losing the existing data. For now if I refresh the page the original data is still there.
Please advise and thank you so much for your time
Based on the response, it seems there may be an addition or deletion of columns from the pre-existing spreadsheet. I can see your hesitation to proceed with apps design due to the fear to lose all the existing data. Hence, I suggest you to create a new personal wistify account and proceed with a new formulary app creation. Only after successful completed it, then you will be brave and competent enough to make changes to the official app. If needed, may drop a message at my facebook page for further assistance.
Delete