Skip to main content

Access and modify formula text in block

  • October 2, 2020
  • 4 replies
  • 25 views

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.


Forum|alt.badge.img+18
  • Inspiring
  • 251 replies
  • 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π


Forum|alt.badge.img+14
  • Inspiring
  • 47 replies
  • October 3, 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


  • Author
  • New Participant
  • 1 reply
  • 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