Product Updates[PRODUCT UPDATE] FORMULA WIZARDS SHEET SYNC

[PRODUCT UPDATE] FORMULA WIZARDS SHEET SYNC

Gayatri on April 30, 2019

We’re pleased to announce new features/changes on Studio (staging) published in this week. Following are the details about these features:

New Feature

  •    Builder

A new wizard has been introduced for adding formulas on any control. The purpose of this wizard is to make the formula creation process much more user-friendly.

When you click on the “F” icon on any control, a new menu will open that will display options to add formulas in the following way

    • Static data – when you click on this option, a modal will open where you can directly input Static data.
    • From Sheets – when you click on this option, a modal will open showing a list of all Sheets in the channel. Selecting the desired sheet will show a list of all columns in that sheet. When you select the column and click on Save button, a LOOKUP formula with the selected column will be auto-generated and saved in the control. You can also apply filters for building the LOOKUP formula in this option.
    • From Controls – when you click on this option, a modal will open showing a list of all the controls (control’s unique name) present in the current app. You can select any control to bind the data from that control.
    • Formula popup – this option will open the existing formula modal.

 

Changes/Modifications

  • Builder
    • Users list control has been updated – Column order for binding data to user list control has been changed.The User list control will accept data in the following column order:
      Image, Left_title, Left_subtitle, Right_title, Right_subtitle, Right_title_color (optional – but should be a #hexcode value and should be in column), Right_subtitle_color (optional – but should be #hexcode value and should be in column), and any additional columns.For e.g. if we want to fetch data from a user’s sheet – UsersDummy, the lookup will look like –
      LOOKUP([UsersDummy.profileimage,UsersDummy.name.first_name,UsersDummy.email,UsersDummy.dateofbirth,UsersDummy.dateofjoining]).
    • Workflow Analytics details: Load more on scroll down will fetch additional data
  • Sheets
    • Sheet Sync mechanism, sheet performance as well as user experience have been optimized.
    • Loader appears when screen size reduces to hide distorted UI.

Fixes

  • Sheets
    • Summarised values was not working for composite columns.

 

  • Builder
    • Rollback crash issue resolved. There will be no data loss if rollback fails.
    • CALL API function content type mismatch issue resolved.
    • File Upload and Sheet Lookup controls updated – controls now reset to its initial state when data is submitted from the form.

 

 

For the curious souls, here is a signup for early access to DronaHQ Low code platform . Please reach out to me if you would like to know anything specific on Low code/ No Code capability.