Hi there?
I found a baserow yesterday, so I tried to install it locally via docker image, so it works fine.
But I found a super big problem.
Let’s say, for example, I have 2 tables named “Clients” and “Services”.
And I have a “Name” field in Clients table, and its linked to “Client name” field via Link type in Services table, so I can see clients name in Services table.
BUT!!! I have a super big problem.
I opened 2 tabs with Clients and Services table on my browser.
When I update Name field in Clients table, changes should be applied automatically in to “Client name” field in Services table like airtable.
At the beginning, I expected, it will be updated real-time automatically, BUT!!! Nothing happened.
I will have to refresh a web page(Services table) manually every time to check any changes.
I think , this is really critical problem or am I missing something?.
Please help me.
Thank you so much.
Ah yeah, I see.
I saw this on landing page. So I thought, this is done already.
Thank you so much! Great @olgatrykush
I really really appreciate your efforts.
Can I know when will it be implementing?
I have another critical issue with using an API.
I have imported all rows successfully from Airtable to baserow using a script that I built.
But only 1 row has an issue, when I try to create a new row using baserow API, it keeps returning a 500 internal error.
So far so good, but only 1 row is a problem.
So, I tried to create a row using Postman,
As you can see, the request body is correct.
I have the Clients and Orders table.
In the request body, the “Client” field is linked to the Clients table, so I added the row id of the Clients table as an array.
7988 row ID is available in the Clients table.
Weird thing is if I remove “Client” array from body json, api works fine.
I have created over 6000+ rows in the Orders table with links to the Clients table.
But only this row is not creating with 500 internal server error.
I don’t understand what’s wrong.
I am fighting this problem for a few hours. Omg!
Please let me know what I am missing / what’s wrong.
I found the 500 error problem.
It was because of lookup field in baserow. Hmmm…
When I have lookup fields and try to create a new row using api, it keeps returning 500 internal error.
Once I removed lookup fields and a new row was created successfully via api.
[POSTGRES][2024-02-27 07:27:46] 2024-02-27 07:27:46.862 UTC [78317] baserow@baserow ERROR: cannot extract elements from a scalar
[BACKEND][2024-02-27 07:27:46] 127.0.0.1:40136 - "GET /api/_health/ HTTP/1.1" 200
[BACKEND][2024-02-27 07:27:46] ERROR 2024-02-27 07:27:46,865 django.request.log_response:241- Internal Server Error: /api/database/rows/table/522/
[BACKEND][2024-02-27 07:27:46] Traceback (most recent call last):
[BACKEND][2024-02-27 07:27:46] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
[BACKEND][2024-02-27 07:27:46] return self.cursor.execute(sql, params)
[BACKEND][2024-02-27 07:27:46] psycopg2.errors.InvalidParameterValue: cannot extract elements from a scalar
[BACKEND][2024-02-27 07:27:46]
[BACKEND][2024-02-27 07:27:46]
[BACKEND][2024-02-27 07:27:46] The above exception was the direct cause of the following exception:
[BACKEND][2024-02-27 07:27:46]
[BACKEND][2024-02-27 07:27:46] Traceback (most recent call last):
[BACKEND][2024-02-27 07:27:46] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2024-02-27 07:27:46] raise exc_info[1]
[BACKEND][2024-02-27 07:27:46] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 43, in inner
[BACKEND][2024-02-27 07:27:46] response = await get_response(request)
[BACKEND][2024-02-27 07:27:46] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 253, in _get_response_async
[BACKEND][2024-02-27 07:27:46] response = await wrapped_callback(
[BACKEND][2024-02-27 07:27:46] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
See this guy has the same problem.
Can I know why this happened?
This sounds like I can’t use lookup fields??
Have your team fixed this problem in a new version or not?
Hi @Long, would you be able to share more details about your database schema when this error happened? It looks like a bug in the lookup field, but us it’s important to be able to reproduce the problem to fix it.
Hey @Long, currently, this feature is a low priority for us, and we decided to leave its position as it is. However, if we receive more requests or comments about it, we will reconsider its priority.
@olgatrykush
I’ve just stumbled upon this issue and it is a bit surprising to me too.
It seems that changes made in the linked field select modal (aka a pop-up window/menu ) are reflected instantly in the source linked table, but when one changes the value in the “source” table, a refresh is needed in the other table.
This actually is a problem for people working on real-world projects as teams, on the same table, at the same time… which I assume comprise a huge portion of Baserow’s target audience (people or companies transitioning real ‘data rich’ projects from Airtable/Excel/etc to Baserow)
) are reflected instantly in the source linked table, but when one changes the value in the “source” table, a refresh is needed in the other table.