Discussions

Expand all | Collapse all

Formula changes

  • 1.  Formula changes

    Posted 21 days ago
    Edited by Don Larson 21 days ago
    This promises to be a major change.  Having to build relationships that do not really represent the data structure to get an answer in a report has been quite convoluted.    Harrison Hersch posted this yesterday: 

    https://community.quickbase.com/blogs/harrison-hersch1/2021/01/05/improvements-to-the-qb-formula-engine-kicking-it-i

    The $60K question is if we can look at other tables and query on dates.  That would be a game changer.  Tom Leverone posted a piece in November showing exactly the type of problem.

    https://community.quickbase.com/blogs/tom-leverone1/2020/11/23/quick-base-analytics-using-moving-averages-to-iden?CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804  

    His solution is very creative but it means baking into the application a structure that has nothing to do with your underlying business problem.

    Hopefully there will be a meaningful demo soon.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------


  • 2.  RE: Formula changes

    Posted 21 days ago
    This will be a game changer.  The syntax will be a bit tricky due to its power, but very powerful for a power type app builder who (like you and I) are not real Javascript coders,  and do not want to introduce complex Javascript code pages into their apps written by hired hands.

    I can't wait!

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------