Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What are the exact steps to reproduce this issue?
I have a table with our inventory and this has an Autonumber field as its primary field. In a second table “Changes” I’m tracking changes on these inventory items. So I have a Link-to-Table field named “Inventarnr.” (in English: “Inventory number”) that links to “Inventory” which means it shows the Autonumber field.
Now I found two problems filtering data in “Changes” on this field:
in the Application builder the Data Source filter to “Inventarnr. HAS” parameter (see screenshot 1) doesn’t work as it delivers no result. As a workaround I use “Inventarnr. CONTAINS” but as an inventory number like 18 also “contains” “8” this makes no sense (but at least delivers results)
in Baserow backend I try to filter the table “Changes” with the field “Inventarnr.” to 8. But the pop-up window doesn’t work as the blue circles don’t stop to circle (I guess it shows that Baserow tries to fetch the related data?). See Screenshot 2. I can’t replicate Number 2 so this is not valid anymore.
For your first issue, I was unable to replicate the problem. Here are the exact steps I tried:
Created a new Database table, named it “fruits”
1.1. Added a column called “name” and added a row with the value “Apple”
Created another new Database table, named it “changes”
2.1. Added a Link to Table field, pointing to the “fruits” table
2.2. In the Link to Table field, added a link to the “Apple” row
Created an Application builder app
3.1. Created a Page parameter named “fruitId” of type “Numeric”
3.2. Created a Data Source for the “changes” table
3.2.1. Created a Filter where the link to table field “has” the value of the Page parameter
3.3. Created a Heading element that displays the value of the Data record
When I follow these steps, I’m able to see the value “Apple”. If I replace steps 3.1 onwards to use a Query parameter instead, I’m also able to see the value.
Can you give us a detailed list of steps to reproduce the problem?
Hi @jrmi thank you for helping here.
I think the most important aspect is a Autonumber field. Could you add to your table “fruits” a new column with "Autonumber"and use this as the primary field? Let’s say that the apple gets Number 3 (from the Autonumber field) and between many other fruits there is a pea with Autonumber 13.
Can you use this Numbers as the the page parameter or even as a filter option in the Baserow backend? Can you filter for 3 and it shows changes to the apple and only the apple (not the pea with its 13)?
Hi @olgatrykush ,
I don’t know what happend but now the filter offers correct “is” instead of the “has” (see my old screenshot).
And now filtering works as expected.
So you are right: it can’t be replicated. I edited and updated my post.
Even with the Autonumber field, I’m still unable to reproduce your error. Here is what I tested:
Created a new Database table, named it “fruits”
1.1. Added a column called “name” of type Single line text
1.2. Added a column called “myAutoNumField” of type Autonumber
1.3. Added a few rows, “Apple”, “Banana”, “Cherry”, etc.
1.3.1. Added up to 12 rows, so I can test both 1 and 11, as well as 2 and 12.
Created another new Database table, named it “changes”
2.1. Added a Link to Table field, pointing to the “fruits” table
2.2. Created a bunch of rows; each row is linked to the corresponding row in the “fruits” table
Created an Application builder app
3.1. Created a Page parameter named “fruitId” of type “Numeric”
3.2. Created a Data Source for the “changes” table
3.2.1. Created a Filter where the link to table field “has” the value of the Page parameter
3.3. Created a Heading element that displays the value of the Data record
When I follow these steps, and I enter a value for the Page parameter (e.g. 1 or 11), I’m able to see the correct value in the Heading element.
As before, if I replace steps 3.1 onwards to use a Query parameter instead, I’m also able to see the value.
Also, are you sure you’re using a formula to specify the Page parameter or Query parameter in your filter? In your previous post you mention that you used “CONTAINS”, but that wouldn’t be a valid option to use with a formula.
Could you please list out for me the exact steps to reproduce the problem? Please follow the format like the one I wrote above, to avoid any confusion and misunderstanding. If you can, please share a screen recording to demonstrate the problem.
I also tried it with a new table. It worked as expected as long as the Autonumber field (as the primary field) is exactly the same as the Row ID.
But it doesn’t work if Autonumber in primary field is unlike Row ID.
See screenshot
It shows changes with the parameter 7 for the “pea”. But 7 is not the Number from the Primary field. It is 1.
If I enter 1 as the sites parameter no data shows up (no “Changes”).
So my understanding is that the data source is able to find data with a matching row ID but DON’T uses the primary field (or isn’t able to filter on it)
@paljort if I may ask you to use the table that you’ve build before and:
select another field as the primary field
delete some of your records so that the last Row ID is larger then so amount of rows (last row ID is 12 but only 8 fruits if you’ve deleted 4 before)
reset the Autonumber field so that it starts new. The last Autonumber should be something like 8. IMPORTANT: Autonumber and Row ID should be unlike (at least for some of the data)
select the new generated Autonumber field as your primary field
try the Application you’ve build and test if you get the results that you expect.
I’ve moved this Thread to the section “Application Builder” as for my understanding it is a problem of the Application builder (was in section “Technical Help” before)