In a “collapsing list” column I have entered several options that can then be selected in dedicated forms.
The issue is, I can’t add new options ; when I try to it just seems to be loading forever until it simply stops, without saving the new option.
If I try to do it again within a few minutes, it gives me an error message “Field is impossible to modify”
Describe, step by step, how to reproduce the error or problem you are encountering.
I click on “modify this field” in the adequat column then on in the “collaspe list” section I click on “add an option”, add it and then click “save” and nothing happens.
As said before, if I refresh and redo it an error pops up saying that something is already using this field (which I believe to be my previous attempt failing over and over again …)
Can you help please ?
Provide screenshots or include share links showing:
How many rows in total do you have in your Baserow tables?
5494 row on the 30th of May at 09:58 (GMT+2 - Paris)
The more I play with our Baserow the more I’m thinking the issue lies in Baserow’s calculations.
Right now I’m having trouble just deleting text from a text column ; it just won’t disappear…
We’re growing pretty rapidly so all those error pilling up are becoming critical ; is it possible to benefit from an online assistance via visio or something ? That would be super helpful since I could present the different issues at once.
Hi @Paragon, are you self-hosting Baserow. If so, can you share as much details on how you’re self-hosting, and maybe also share more about the API requests that are being made to your server?
We have several tags to qualify the event we’re creating :
one with the Type of event
one with the “physical manifestation/online manifestation”
one with the category of the event
Those 3 tags are then added together in the “Nom” column via this formula :
concat(if(and(equal(field(‘Ouvrir à l'inscription’),“Oui”),field(‘Date’)>=now()),“→”,“”),field(‘Logo’),if(equal(totext(field(‘Type’)),“Réunion”),“”,field(‘Type’)),if(isblank(field(‘Catégorie’)),“”," “+totext(field(‘Catégorie’))),if(isblank(field(‘Ville’)),”“,” “+field(‘N° département’)+”-“+field(‘Ville’)),if(equal(totext(field(‘Réunion’)),“Physique”),”“,” visio")," ")
Hi @Paragon, if you add an option to your field, and there are formulas referencing that field, it will recalculate the call values of those formulas as well. If you have multiple formulas depending on other formulas, depending on that field, it can trigger a chain of multiple formulas needed to be recalculated. In some cases, this can result in a long loading time.
How long does it take if you edit the Nom field and click on the save button? This can help me give a better understanding where the formula problem lies. Are there also other formulas referencing the Nom field?
Thanks for the explaination. I’ve tried changing something random in the Nom column ; it takes 2 mins to stop loading and prompt “connection error” and no change is made
Hi @Paragon, I suspect this is then related to the currently slow computing of formulas with multiple references to other fields. A performance improvement will most likely be deployed to baserow.io Around the end of next week. Meanwhile, we’ve increased the timeout to 3 minutes. That might help you for now. We’re also going to work on a way for formulas to compute async, so that the computing time can be even longer, but that might take a bit longer to compute. Apologies for the inconvenience.
