For instance, can a formula field refer to a formula baked into the extension?
Here’s the use case:
I’m building an licensing app. If the user has a license key, the formula in the formula field will work. If the user doesn’t have a license key, the formula in the formula field will not work.
Formula fields can only refer to other fields in the same table. They have no access to extensions.
Hm. I was wondering if someone knew something I didn’t.
I know an extension can create fields/records etc. I know it can also read from records. Just trying to figure out a method that will help prevent piracy.
Either way, thank you! You’re a legend, Kuovonne! Any time I see you in a thread, I know that it’s solved.
While extensions can read and write fields and record data, the reverse is not true. Extensions also cannot create or modify formula fields. When it comes to formula fields, extensions can only read the formula results.
It isn’t possible to create or edit a formula field programmatically.
You can lock your extension with a license key, and then have the extension write to an editable field only if the license key is valid. However, once the data is written to the editable field, anyone can see it (unless you extension also deletes data, which I highly recommend against.)
Extensions also only run when they are open.
That is precisely why I have lobbied Airtable to make custom formulas through javascript possible. All I get is pushback from the community and Airtable for a capability that has existed in Google Sheets and Excel since most of you were in grade school.
I tend to try to work with what features are available now and speculate on why features have not been implemented. Coming up with reasons why things haven’t been implemented makes me less frustrated at not having them.
But I’m slowly coming around to your point of view regarding custom JavaScript functions.
You’ve got me believing that having formulas for all field types makes sense.
Change takes time.
Lol. I guess I’m not most people. I was out of grade school before Excel was created. I was retired before Google Sheets was created. I didn’t even know that user defined functions existed until you mentioned them, so they still feel new to me.
Coming up on a decade. [ticking sound]
I was referring to having me change how I think of things taking time.
Yeah, I’d like Airtable to change things faster. But I’m not in charge of making those decisions.
It would be nice if Airtable took feedback from the community. But it seems to take a firestorm for Airtable to respond to community feedback, and those firestorms usually related to Airtable breaking things that used to work versus new features. This speaks of company culture.