Blog Post

The Qrew Blog
1 MIN READ

Quick Base Release Notes for March 2019

EvanMartinez's avatar
EvanMartinez
Quickbase Staff
6 years ago
With the March release, we're introducing our new Visual Builder and Settings panel. The drag-and-drop app-building interface and consolidated Settings panel will make it easier for new builders to get started.

We are also giving our existing builders more tools to create robust and powerful apps with custom data rules, improvements to APIs, and deeper insight into how fields are being used.

This Month we are spotlighting:
  • Visual Builder
  • Power BI certified connector
  • Custom data rules
  • Mobile app-Table access and new My Apps page
Full details on the release can be found in the release notes new home in Quick Base Help:

https://help.quickbase.com/release-notes/march-2019-release-notes.html

The March release of Quick Base, including the features and fixes listed in these release notes, will be available starting Sunday March 24th, 2019 once our release is complete.

Release Features
  • API Improvements
  • Field tracking improvements
  • Admin Console new experience for all & new app management pane
  • Rich Text fields can now be used in report formulas
Early Access
Announcements:
These highlighted features and more can be found in further detail in our March release notes. To keep up with upcoming releases and status updates for the Quick Base Platform you can always check our Status page.
Published 6 years ago
Version 1.0
  • AnnSwelgin2's avatar
    AnnSwelgin2
    Qrew Member
    6 years ago
    Was there an update to quick base that changed how a jpg is presented in a form? I have a formula rich text field which used to present the jpg i would attach as an image that filled up the form. Now when i go in, the jpg is about 1/10 of the size to the point where you can't read what is in the image unless you click on it (which I'm trying to avoid). I tried adjusting the width and height in the Formula section of the field, but that didn't change anything?
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    Hi Ann,

    We didn't alter the way formulas would display images in Quick Base but we did offer an option for file attachment fields in our February release to now display the image directly on the form. The image that displays directly on the file attachment field is a thumbnail so it is smaller in size but it shouldn't impact the way the separate formula field displays. Are you using a formula similar to: 

    "<img width=\"500\" src=\""& URLRoot() &"up/" & Dbid() & "/a/r" & [Record ID#] & "/e9/v0\" />"  
  • LeanneSnoeck3's avatar
    LeanneSnoeck3
    Qrew Trainee
    6 years ago
    Where do we build the custom data rules? I cannot find this in any of the settings, but I also do not know what I'm looking for. Thanks!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Advanced settings for the table.

    Note that while there is a link there for some help, the undocumented trick is that you are building a formula text field that will calculate an error message which will be displayed to the user.

    If the error message calculates to null, then it will save, else the save or entire Grid Edit save will be blocked and your error message words will display.
  • LeanneSnoeck3's avatar
    LeanneSnoeck3
    Qrew Trainee
    6 years ago
    Have you had this work with a text formula expression or does it only work with a numerical outcome? We are not getting it to work looking at two text fields, one being populated and the other being blank.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    It should be a formula text field type as it calculates the error message.  That works fine for me.  
  • JonathanHeuer's avatar
    JonathanHeuer
    Qrew Cadet
    6 years ago
    I really like the dependency diagram. Trying to figure out the red/blue color coding...  Also, it would be great to show the whole field name on rollover.
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    Hi Jonathan,

    It should be that any blue dots are derived fields either pulling data via a Lookup/Summary or a Formula and the red dots should be static fields that data is input into. Those fields in red can still be fields that are updated by Automations, Webhooks, and APIs but they aren't directly being calculated in that field. 
  • QuickBase9's avatar
    QuickBase9
    Qrew Cadet
    6 years ago
    I get the final output is text, but in your answer earlier you said you are solving for "null" which in my text expression I'm solving for "true" and the error message is not popping up, so just trying to figure out why it would not work.
    ex. If( fieldA=xyz and fieldB="", "text message and no save")
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Aside from the syntax, that should work. 

    If the formula calculates to any non blank text, then the save will be blocked and the words will be presented to the user as the reason for the blocked save.