Sachin Duggal : Questions about formula and API

1

Hi Team,

I’m Sachin Duggal , and I am the owner of a bags manufacturing business, I’m working with a table in Baserow and using a formula, but one of the parameters is dynamic and needs to be sent via API. My goal is to insert this parameter into the formula and get the calculation results for all rows (thousands of rows) in the table.

Here are the methods I’ve considered, but I haven’t been able to complete any of them:

  1. How can I send a parameter via the API and insert it into the formula? Is it possible to update the formula dynamically via the API?
  2. Can I update all or multiple rows in a table with a single API request?
  3. Is there a way to get a link to a specific cell (not a column) without using the API?

Are there any other approaches or solutions you would suggest to achieve this goal, without relying on third-party integrations?

I would really appreciate your input and advice. Thanks in advance!
Regards
Sachin Duggal

2

Hi @sdbags,

  1. You cannot have a dynamic formula parameter as you described. You can however update a formula field when you need to via API the same way you would update any column. See update_database_table_field This will have performance impact.
  2. Yes, we have a batch endpoint to update multiple rows: see the API docs here: batch_update_database_table_rows.
  3. When you open any row in a grid view you can notice that the URL will change, e.g. to https://baserow.io/database/XXX/table/YYY/ZZZ/row/OO. So every row in a table has a link that users can navigate. This is however not a link to a specific cell.

Hope this helps!