Can't Recreate Formula From AITable

Bika.ai discussions
1

I am having a hard time replicating a formula from AITable, one of the main reasons for this is because we do not have the API Panel (which made it BEYOND simple to build when working with the platform). Please incorporate this feature again.

The formula I am trying to re-create displays the url of the file in the database. For some reason I can’t replicate it in Bika.

IF({File},
MID({File},
FIND(“(”, {File}) + 1,
FIND(“)”, {File}) - FIND(“(”, {File}) - 1
),
BLANK()
)

Any help on this would be great.

2

Thanks for the feedback and for sharing your use case!

Bika.ai is designed a bit differently from AITable.

You can refer to this guide to extract the file URL:

Here’s the Bika OpenAPI documentation for reference: https://bika.ai/help/openapi/bika

Thanks again for your feedback — I’ve shared your feature request with our product and engineering teams.

3

Sorry, but i am very confused with your response.

  1. You guided me to something that has nothing to do with my question in any capacity.
  2. If you do not actually know the answer, I think it would be better to say that instead of leading a user somewhere they do not need to go.
  3. What is exactly different in the design?
  4. is there someone else on the team that actually knows about formulas?
4

Hi @Chowderr , thanks for the follow-up!

You’re absolutely right, and sorry for the earlier confusion.

At the moment, Bika.ai doesn’t yet support formulas that can directly extract file URLs from file-type fields , like the one you mentioned from AITable.

For now, the only way to achieve a similar result is by using a script or API call, as shown in the resources shared above.

I’ve already passed this to our product and engineering teams for further review.

Really appreciate you flagging this so clearly, we’ll keep you posted once there’s an update.

5

@Chowderr

  1. Since Bika and AITable have different product characteristics, Bika does not have an API panel; therefore, it cannot be viewed directly through an API panel.

  2. If you would like to obtain the file URL, you can follow the steps below:
    – Open the API documentation and locate the List Records API endpoint
    – Send a request using a third-party API tool (e.g., Postman). The file URL within the record will be returned in the API response

image
image1505×908 104 KB

6

I appreciate your comment but I am not sure if that really needs to be said. Also as a technical user of AITable and Bika I can see a ton of things are the same…regardless of how different they are in the backend.

  1. You guys say that this feature (API Panel) is coming so I am confused on your comment. You guys said Bika was supposed to be an improvement from AITable, if that is not the standard anymore then :+1: nonetheless it was a great feature.

  2. I have figured this out, I was just more curious why we have to search when the information is already there and I am using that record. Your responses answers my question/assumption: You are not using V2 API here that is way the information is why less.

7

Hi @Chowderr,

Sorry if my earlier message came across the wrong way, that wasn’t my intention. Bika.ai is currently more focused on AI and Agent features, while Automations and backend logic work very similarly to AITable. You clearly have strong technical experience with both platforms — really appreciate the time you took to share such detailed feedback. :pray:

Just to clarify, we haven’t officially announced an API Panel feature for Bika.ai.
When I mentioned sharing your feedback with the team, it was simply to ensure your use case is reviewed — not to suggest it’s already on the release plan.

Bika’s API was recently upgraded to V2, and some documentation updates are still in progress, sorry for the confusion that might have caused.

Thanks again for the thoughtful feedback, it’s always appreciated!