Wistify.app
Introduction
Wistify.app is a mobile application developed by My Pharmacist House and its team.
- It aims to help users to convert existing spreadsheets into a mobile applications without coding.
- The free basic package includes a limit of 2 wists, a maximum of 1800 data rows and 1 GB of monthly user downloads. Additionally, 1 GB of storage is provided for the file manager feature, with 10 GB of monthly bandwidth.
How to Start Creating
NOTE: Enabling the Custom Sort option in Apps Design allows data to be displayed according to the data grid sequence. Otherwise, the data output will follow the alphabetical order of the headers.
Pros
Overall, the Wistify. app offers several noteworthy features.
- Freemium plan (free plan with basic features).
- Ease of use.
- Offline installation capability.
- Automatic database update notifications.
- Password protection.
- Notice board integration.
- File manager upload for images and PDFs.
Cons
- Consequently, users must save Excel files as CSV before importing them.
- This limitation results in the loss of all formatting, as CSV files are plain text and cannot retain font styles, colors, cell borders, or conditional formatting.
Furthermore, Wistify provides only a basic data display of spreadsheets.
- Headers remain visible even for blank fields.
- The platform also lacks the ability to create multiple pages or build functional apps with calculations, embedded URLs or other interactive elements.
Tacking Google Sheets Synchronization Issues
While Google Sheets synchronization is available, the following conditions must be met to avoid issues:
- The URL link is shared from a Google Sheet, not an Excel file (which may be titled with a ".xls" extension in Google Drive).
- The Google Sheet must be made public before the URL is copied.
- The sheet must contain fewer than 65 columns.
- The header row (first row) must not be empty.
- Header names must be unique (no duplication).
- Headers must not contain special characters ($#[]/.).
NOTE: Automatic data synchronization with Google Sheets is unavailable. Users must manually initiate the 'sync complete' process and publish database updates.
Privacy Reminder
For privacy concern, protect your wistify.app with a password lock.
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