<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Subscribe to Our Blog Stay up to date with the latest tips and news.
Filter By:
Sort By:

Santiago Uribe

Santiago Uribe
Santiago is the VP of Product at AppSheet. He is a relentless customer advocate. He loves building partnerships and driving customer adoption. Prior to AppSheet, Santiago worked at Microsoft, got an MBA from CMU and worked in international trade development in New York and Bogota, Colombia.

Recent Posts

How to add multi-language features to your apps

During an impromptu webinar, we talked with two AppSheet app creators working on multi-language apps. We discussed and share tips and tricks to add multi-language features to apps. Thank you Juri and James for your questions and insight!   Table of Contents:   01:13 - Data switch with partitioning 11:18 - Multi language in UX 25:06 - Dataset switch with expressions

Feature Friday: Add Tabs to Your Forms

Quick update from AppSheet central this week. We recently released a feature that will make your forms much easier to navigate, braking them up in sections and letting your users navigate the forms in a more visual way. Continue reading to learn more.  Feature of the week: Tabs in Forms. If your forms have multiple sections and you are using columns that are SHOW Type, you can make those columns page headers and show them as tabs in your form, this  greatly improves navigation in forms. You can customize the name of each tab or even use an expression to dynamically generate the name of the tab. Learn more about it by checking the video below and reading Sarah's post..   What do you think about the most recent release? Share your thoughts in community.appsheet.com See you next week!

Feature Friday: We're back!

It's been a few weeks since out last post and it's time for a new Feature Friday. We've added a few early-year features for your app creation pleasure. Check them out! Improving app performance:  We are increasing our focus to both help you understand and improve the performance of your apps. App responsiveness is the single most important element of end-user satisfaction. So for us and for you as app creators, this is an area of continuous improvement. Read Praveen's post about improving performance. User Roles:  Many apps have different functionality or behavior for different categories of users. The most common scenario is to have employees and managers, or users and admins. Based on the category of the app user, some features are available or they are blocked using expressions. Each of our app creators needed to implement this themselves using a lookup table of user emails and categories. Instead, we're baking this into the user whitelist/security model. Read More. Updates to Show type columns and format rules :  You can now apply format rules to Show type columns when they're in Detail Views! This includes Section Headers, Show Text, and Show URL columns. See what Sarah G from the engienering team just released! Buttons for Ref columns!  You can now use Buttons for your Ref columns! Like Enum columns, you can open up the column details (Data > Column Structure) and change the InputMode to "Buttons." Then in forms and quick-edit columns, you'll get buttons instead of the drop-down menu. Just be careful if you have a large number of possible references... you could end up with a LOT of buttons this way. :) See the announcement.   USEREMAIL() alerts: If you have any of the Publisher subscription plans, this means that users cannot sign in to your apps and they are tagged as guests. For a while we did not check the usage of USEREMAIL() in expressions for apps in Publisher plans. We now include an alert if you use the expression in an app that doesn't require sign-in. Find more details here.    What do you think about the most recent releases? Share your thoughts in community.appsheet.com See you next week!

Feature Friday: Stocking Stuffers 2017

We're moving into holiday mode at AppSheet central. Nine more days until the end of the year and in keeping with the spirit of the season, we've released a number of new features. The features range from simpler concatenate expressions to adding a photograph to your drawings. Continue reading to learn more. Picture in drawings:  We added a new control for Drawing type columns which allows you to take a picture directly from the drawing pad and then annotate it.  To create a drawing field in your app, simply change the column type to Drawing in Data > Columns Video column type:  Some of of you are working on delivering training materials to teams, vendors, and new employees and have asked us to enable video display as part of apps. We are now happy to introduce support for video in the Detail and Form views. This way you can include a video snapshot as part of the app experience.  Video columns are available as a column type in Data > Columns. Simply populate the cell with the URL to the YouTube video and AppSheet will render it in the app. URLs pointing to MP4s also work. Simpler concatenate:  You can now write expressions that combine multiple fields by using the inline text concatenate operator '&' which is a common method to concatenate values in Excel formulas. Before, you would concatenate values with a formula CONCATENATE([A],[B],[C]...), now you can simply write [A]&[B]&[C]... and get the same result. Filtering of references:  Whenever you create a reference between two tables, a parent-child relationship is created between the two and the parent table automatically gets a virtual column with related items. That way you can see a list of related items for every record in the parent. We updated our expressions to support easier formulas based on that virtual column, so you can do things like adding-up or counting related values. We made an app to show you how it works. Check it out.   Dynamic display names for actions:  We now allow action display names to be based on the content of the current row. So for example, if there is an action called Contact on a Customer table with a column Name, the action's display name can be "Contact" & [Name] --- so you'd see "Contact Praveen" or "Contact Bob" etc, changing from row to row. Likewise, the display name for a Detail view is shown in the app's header bar. This can also be dynamic and depends on the current row being shown. Performance analyzer: The performance analyzer gives you more details on how your apps are being used. You can filter performance profiles by user ID, by table, and display different aspects of the app behavior. It will help you identify trends and problematic devices in across multiple users.  Add charts to reports:  We are testing a new feature for your email templates called SNAPSHOT. When you create a template for email or PDF distribution, sometimes you want to add graphics to it. With SNAPSHOT you should be able to create it. This feature is still in beta and may not produce all the results you want, so please test it and let us know what you think.   Upgrades to My Team: You'll start seeing updates to My Team in your AppSheet account. My team lets you collaborate with other app creators in your domain, sharing apps as templates and allowing you to collaborate and connect. We'd love to get your feedback on the types of features that you want to see in My Team. Please connect with us via community.appsheet.com and let us know! What do you think about the most recent releases? Share your thoughts in community.appsheet.com See you next year!        

Feature Friday: Chat With a Bot and Improved Form Styles

  Welcome to Feature Friday! First week of December and lots of updates to share.  We've recently made our chatbot functionality into public beta and it's available in the app editor and will soon be available in Facebook Messenger (other platforms to come).  Leave your comments about new features here! Open as Chatbot:  Some of your app users may prefer to interact with you via chat instead of a stand-alone app. That's why chatbots have been growing as a customer engagement tool for businesses of all size. We are happy to introduce chatbot functionality in AppSheet apps! This will help you create structured and conversational data capture methods as well as help people navigate the data in your apps in chat mode. Want to see some examples, go to our samples page and search for chatbot to see some possibilities. Chatbot App will be released for Facebook messenger (still in Beta) and we'll be adding other places that accept chatbots in 2018. Stay tuned for more news in the next Feature Friday. Side-by-Side form style:  We've retired the old, broken Horizontal mode, but we think you'll like this much better. You can access it under UX > Options > Form Style. Bonus: This update will also make quick edit columns match the rest of a side-by-side detail view. Find side-by-side as a form style option in UX > Views > Form > Form Style Sample apps update:  In an effort to help you find the right app to learn a new patterns or to use to get started with your own app and then customize it, we've updated the samples page with a search function that can identify certain keywords and list apps that you can copy or take a peek how they're created. Check it out. How-to sample apps:  Now that we're making it easier to navigate our samples, how about adding a new type of app for your learning pleasure? As part of our support efforts we have created a great number of apps that show specific aspects of app creation, they can concentrate on showing how to create a dependent dropdown or calculate the MAX value of a column to create a consecutive number. While those apps don't have a lot of functionality as apps, they are great didactic resources. Check out our how-to apps in AppSheet's customer support page.  Plan requirements are now available in the Manage tab: If you want to evaluate which plan is required for the app you are creating, go to Manage > Author > Plan requirements and you'll get a tool that evaluates all the features that your app is using and if the app would be allowed under the different types of plans. This can help you make a better choice of subscription plan before getting your app deployed.  Scheduled workflows are now called Reports:  You can automate actions with AppSheet in two ways, immediately after data changes and through a scheduled report. Data change workflows require the app user to take an action in the app to trigger the automation. Schedule rules... well, work on a schedule. We moved scheduled reports to a different type to better reflect the difference between both and for our users to have more clarity on which types of workflows they can run based on their subscription plan.  Find Reports in Behavior > Reports. And check our YouTube channel for tutorials and webinars about scheduling and automation! What do you think about the most recent releases? Share your thoughts in community.appsheet.com See you next week!  

Feature Friday: Progress on Postgres, Archive PDFs!

        Welcome back to Feature Friday. Our main release this week is a native connection to Postgres databases. Connect your cloud instance of a Postgres DB as a data source to get started. We're also sharing a set of improvements to workflows in AppSheet. Leave a comment here! PostgreSQL a.k.a Postgres is available as a data source! Postgres let's you scale your data out and provide a better experience for concurrent users of your apps. I was able to create a Postgress instance in Amazon Web Services with no prior experience, and then create an app from Postgress within minutes. Check out this video with a quick walkthrough. Do try it out!     Lots of goodies for automated emails and notifications. Hundreds of thousands of emails are sent automatically from thousands AppSheet apps every month. Check out this video highlighting some of our most recent updates to the workflows engine.        See you next week!  

Feature Friday: 10 Updates in a minute

Welcome back to Feature Friday. We had a pretty active week, tons of new features, performance updates and refinements in the AppSheet platform. We collected the top 10 that we believe you should be aware of. Which one do you like best? Leave a comment here! 1. Page guides in forms. If you have a form that uses multiple pages, you can turn on the ability to display a navigation guide in the form itself. Activate the feature in UX > Views > Form view > Page Style = Page count. 2. Use BEFORE and AFTER values in change workflows. When a change workflow runs in your app, there are two versions of the row being updated, the status BEFORE the workflow is triggered and the status AFTER it runs. You can now use those two values in your workflow rules to better customize how they run. Use the expression [_THISROW_BEFORE].[Column Name] or [_THISROW_AFTER].[Column Name] to get the values for any change workflow you need. Because these expressions are mostly useful in Change workflows, you shouldn't use it in scheduled workflows or in change workflows for adds and deletes.  3. Set policies on multiple AppSheet accounts. If you are in an AppSheet corporate plan and want to manage how other people create and share app in your organization you can now set policies for the team, so people create apps with the limitations that you set. For example, you can require that all apps created under your group to be secured with sign-in, or never let apps to be published if they allow users to delete rows. If you want to learn more about corporate plans, connect with us! 4. Slideshow view is now called Detail view. In UX > Views. You can define the basic data capture and data display behavior of a record. The Form view lets you define the basic form functionality. The Slideshow view would let you define the data display. To make it clearer for app creators, we changed the view name to Details.  5. Detail view now has a Slideshow mode! The name change started to open new possibilities. Maybe you don't want people navigating from record to record in your app.In that case you can turn-off Slideshow mode. It's on by default, turn it off if you want people to always go back to the previous view. 6. Send workflow PDFs directly to Google Drive. If you have a workflow rule that generates a PDF attachment in an email, you can now also archive it in your Google Drive if this is necessary for record keeping. 7. Lock Signature Input We've made it easier to navigate in forms that have a signature input. If the signature input is locked (usually locked after capturing the signature) then you can scroll through the form by tapping over the signature as well.  8. Interactive Dashboard updates. In interactive dashboard views, if you select a row in one view and then change something in another view that hides that row, that row will get deselected. This will make the use of interactive dashboards a bit smoother.  9. Progress column type now uses theme colors. This one is for all the project managers using AppSheet apps. The project progress column type displays a Harvey Ball which get's filled out based on a selection from empty to full. The progress column will now be shown using the theme colors of the app. Nice! 10. User Settings refresh. Not a new feature but we just published a quick video explaining how to use USER SETTINGS to personalize the app for each user. Check it out!       See you next week!    

Feature Friday: Matryoshka Forms

Welcome back to Feature Friday. This week we are dedicating this space to a single feature release that will take data capture and data management to a new level in your apps.  We're happy to introduce Nested Forms in AppSheet. Nested forms lets you capture, data for multiple tables, giving more opportunities to customize forms. Here's how it works:   Nested Forms: Save data into multiple tables. In short, if you have two tables connected via a reference column, you are creating a Parent/Child relationship for the two tables. The child table is the one that contains a table of type Ref. This means any record in the parent table can contain multiple related rows in the child table. If you mark the child table with IsPartOf, AppSheet will treat the items as a unit, enabling new features in forms, allowing you to add and delete parent/child items together.  When you create a new parent item, you have the option to also add related child record directly from the form. No need to save the record first and add "New" items from a details view.  You can hide any nested forms using the Show_If functionality, you can also make a certain number of responses required by using the Valid_if functionality. In essence, the nested form has the properties of a regular virtual column in your table, you can change its description, if it's required, hidden, or if the content is valid.  Here's a quick video walk through:      Enable IsPartOf in Data > Column > Ref Column type.  Bonus: Use BEFORE and AFTER values in change workflows.  When a change workflow runs in your app, there are two versions of the row being updated, the status BEFORE the workflow is triggered and the status AFTER it runs. You can now use those two values in your workflow rules to better customize how they run. For example you can do things like: Only trigger the workflow if the difference between BEFORE and AFTER is greater than a particular value Use the BEFORE and AFTER values in the subject of your message: "Hey there, thank you for changing from the Standard plan to the Premium plan!" Use the BEFORE and AFTER values in the TO: section if you are changing project owners and want both to be notified.  Use the expression [_THISROW_BEFORE].[Column Name] or [_THISROW_AFTER].[Column Name] to get the values for any change workflow you need. Because these expressions are mostly useful in Change workflows, you shouldn't use it in scheduled workflows or in change workflows for adds and deletes.  We'll be providing more tutorials and documentation on this feature, stay tuned! See you next week!  

Feature Friday: Sliders, Mapping, and Workflows

Welcome back to Feature Friday. This week we're sharing feature updates to forms, a new column type that will get many App Creators in construction and engineering very happy and a recent update to workflows that gives extra power to your apps.     Add your custom image as a map.The XY Column type is a location column where you indicate the image URL you want to display as a map view. The Map view type let's you navigate location items in your tables, to do this you need a location type column like Address or LatLong, and now XY. We use the Google Maps engine to render a map and place the location in it. The mapping functionality lets you add new items on the map by dropping a pin or editing a location inside a form.  Change column types in DATA > COLUMNS in the AppSheet Editor Sliders:  Sliders make it easier to enter a number in a form. It replaces a simple text entry with a... slider where the user can select a number by dragging left or right. If the user taps to the side of the control, a single increment is applied to the bar.  You can activate the slider by changing the NumberDisplayMode option in the column definition. It's possible to set the step value, maximum and minimum values in the column definition as well. Making sure the app users enter data within the range you define.  Additional actions in Workflows:  We've added a new action in Workflow rules, you can now change data automatically when the workflow triggers.  So far, we had Email, Push Notifications, SMS, and Webhook actions in workflows, but many users wanted to also change data automatically by creating an allowed action that's triggered when the workflow's condition is met.   To use a Data Change action, you need to create an action in BEHAVIOR > ACTIONS first to do a data change first. If the action is available to run in the workflow, it will be shown as an option in the workflow rule.  Workflows are available in BEHAVIOR > WORKFLOW Bonus: Major updates to Forms forthcoming. If you have forms with multiple pages or apps with multiple tables and wanted to create dependent items within a form without having to first save the main entry. You'll want to check out our future Feature Fridays. Subscribe to the blog! Also, do you use NOT(ISBLANK()) a lot? You may use this to trigger a workflow, filter or other condition based on a field having any value written in it... Well, our fearless leader got tired of seeing so many nested conditions for NOT and ISBLANK so he came up with ISNOTBLANK() Simply write the column name or expression that points to a column in the parentheses and behappy :)  See you next week!    

2of8