dynamic valid_if/required_if messages
Can AppSheet rub my back after a hard day at work? Nope? Ok then:
1 - at Table view, set SUMMARY LINE on/off. Then set what columns will have a summary and what kind (sum, average, etc)
A summary line should be the last line of a table.
2 - When creating dashboards, having better control of where to put each dashboard item and it’s size.
3 - Be able to set landscape desktop or tablet views Form fields sizes and places. No need to set pixel by pixel like in Access, but a more modular design,
like dividing the screen in 5-10 squares, then drag/drop items to occupy 3 squares width and 2 squares height. This kind of thing.
Change name of buttons or messages as Save, Invalid Entry, Required Entry dynamically, depending of view or other factors.
You wrote "I’d like to see this become more than just a 2 layer reference, allowing for app formulas that pull info from a parent table, 2 tables up from the current, something along the lines [Ref_column].[Parent table value (also a ref field)].[Grandparent table value]. "
Topic “Accessing a Column in a Grandparent Record” in this article may be helpful help.appsheet.com - Template Start Expressions
Template Start Expressions help.appsheet.com
is that notation only good in templates or can it be applied any place we can shove an expression?
+JW R yeah, I’m going to agree with you. My hot list would be
adding a record to completion inside the app preferably through an action. Is a part of records connected so that if I make a copy of a parent, the child records get created as well. Bulk data uploads through CSV, with validation.
Export Charts to PDF directly to the users Phone.
Sorry for bit long lines, but those are on my wish list.
Download workflow template complete file to user device (not through email)
Output file type option (excel, word) in addition to PDF on workflow rule.
Function like SQL Trigger (such as adding row(s) to child table when new row added a parent table)
Function like SQL Union (merge) tables
Upload file from mobile device
Automatically generate workflow template file (PDF) periodically and save the output file to a designated/targeted table/column (currently user output PDF by workflow rule and receive email. Then upload PDF file to a certain column through form of the app. Love to make this process automated)
Integration with external map service, such as Mapbox
Adding custom map layer
Advanced filter (column selection) on table view like Excel. By clicking column name on table view, then drop down list pop up, tick on/off to filter rows by certain columns. User can generate own table view
Users option to select column on table view (similar to No.9)
Export data to Excel / CVS from table view to user device (data download)
Users option to change sync setting (auto background fresh, sync upon launch, delayed sync -
make those option to users)
Yes, multiple bulk file/image uploads…
@Grant_Stead yes, I wish to have that one as well.
Sometimes, we update our bosses on our job on Whatsapp.
The transition to use app still takes time and confidence.
Maybe AppSheet can have feature whereby all the submitted rows/data can be converted into text (not copy paste) so we can copy it and maybe style it to our likings and paste it in the Whatsapp groups.
Did you find a work around, until this (I agree - very useful feature) is added?
Integration with Firebase/Firestore.
Option to embed external webapp into a appsheet view.
@tsuji_koichi, can you elaborate on your use case?
Firebase is No SQL so not sure if Appsheet can integrate, as appsheet is based on relational data base, but hopefully it can get through.
I m currently on development of own web app where we store data to firebase and files (images) on Firesore as well. It is far more easier if we can natively connect to Firebase/Firestore, rather than coding for own web apps.
Anyway, once the web app is ready, then this external app start to interact with Appsheet app. To deepen the integration level, I wish to put the embeded link to appsheet app (as a new feature), just place the single line of url then appsheet will generate view based on the linked web page. We can achieve similarly by placing action to jump to url for external app, but it just open up on browser, which is less ideal.
Drag & Drop feature for scheduling!!!
That way if my schedule changes all I need to do is drop it the the correct date without switching any of the related data or having to switch views.
Some more from me
Allow someone to upload an Image used by a XY column via a phone or browser rather that having to manually upload it to the web. This is the main reason I don’t use XY column types with my clients
Fix the virtual column issue whereby it shows one value in an inline view then it changes it because of a recalculation in the form view. The ‘simple’ fix would be editing a form view with a VC must cause a sync on all relevant VCs
More control over sync settings. So that we can force syncs by specific changes to data i.e. in the column settings. Also allow us some global sync setting in Behavour -> Offline/SYNC such as controlling background download and upload sync frequency
Expose the data that Xrefs Google Locations to XY co-ordinates
Create multiple rows in a table based on some formula
Have Facebook as an authentication providor
Force images to be square on workflows. Since a mix of portrait and landscape can really muck up the layout
WhatsApp integration will be great!
I’d also like to labour the point on the userbase voting on which updates to impliment. Since without this Appsheet could easily find themselves implimenting what they think is best, or worst, whatever is the easiest. This is the exact senario that Agile Software Development is meant to avoid - https://agilemanifesto.org/principles.html. What no-one wants is a competitor to Appsheet developing a better product that we have to eventually swap over to.
An example of wasted effort for me is the Spec part. What is that part even for? How does it help us develop Apps? Its impossbile to use to it to explain to how the App actually works. Looks to me like it was added because it looks nice and/or it was easy to do.
I don’t think by adding new features and making the overall product more complicated will make it harder for new users to become engaged. The bar for getting a basic App of the ground is as low as it was for me when I started 3ish years ago.
Anyway… rant over
Some of you may find this really useful when developing Apps in general - https://www.youtube.com/watch?v=fEvKo90qBns
I would like to be able to use a drawing of the layout of a building where the image is stored on Google Drive not a website. This is for an inventory type app I’d like to see. I have not found a way to do that.