Skip to main content

Access and modify formula text in block

  • October 2, 2020
  • 4 replies
  • 39 views
M

Hi, I have a formula field that has long SWITCH statement and I want to modify this formula dynamically in backend. Is there a way to achieve this?

    4 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    You can’t modify a Formula field through Custom Apps or the API.

    O
    Forum|alt.badge.img+18
    • Olpy_Acaflo
    • Inspiring
    • October 3, 2020

    Hi @MK_Kim

    This is one of my 5 “most wanted” !

    Fields Properties CRUD from Custom App API !

    Airtable’s DEVs stopped communicating about it
    so I’m trying to ring @Taylor_Savage bell ?

    Best,

    olπ

    R
    Forum|alt.badge.img+14

    Hey @MK_Kim,

    The apps sdk does allow you create (look for createFieldAsync) and modify (look for updateOptionsAsync) fields, which is what my eazyfields open source app does. It just doesn’t allow you to modify formula fields.

    I did also create an open source formulas app, which you may build upon to achieve what you want.

    Cheers,
    Ronen
    Superblocks

    M
    • MK_Kim
    • Author
    • New Participant
    • October 5, 2020

    Hey @MK_Kim,

    The apps sdk does allow you create (look for createFieldAsync) and modify (look for updateOptionsAsync) fields, which is what my eazyfields open source app does. It just doesn’t allow you to modify formula fields.

    I did also create an open source formulas app, which you may build upon to achieve what you want.

    Cheers,
    Ronen
    Superblocks


    thank you for your suggestion

    R
    Terms & ConditionsAccessibility statement