Hello,
Something I’ve noticed today, I can’t export a table if there is a formula that return an “Invalid number” in the view.
Can you reproduce that behavior ?
It would be great to be able to export it anyway,
Alex,
Hi @Alex-Clapp,
Could you share some further details about the formula and the values it is referencing that it ends with an Invalid Number? I would like to reproduce this on our side so that we can look at fixing this issue (if it is possible). It is likely we can fix the issue in the formula so that it does not result in an invalid number and therefore exports correctly.
On top of that, I will also create a report on the separate issue of not being able to export it due to the invalid number.
Hey @cwinhall,
Thank you for your message.
The formula relies on lookups of lines that are created with an automation. So this invalid number occurs, when a number is missing in the automation, independently of Baserow.
I didn’t try it, but I think the export led to an error each time it contains an invalid number.
On my side I managed it making the column hidden then solving the automation.
Let me know if you need further information,
Hi @Alex-Clapp, glad to hear you solved it. Could you provide some details on that solution? Did you solve it in the formula? I’m not entirely sure what automation you are referring to in your post.