Notion data Base

[caporali]

Hello

I have an issue to retrieve the value of formula in my Notion Data Base

They do no appear correctly (instead of number, I get information → see attachment)

Is there an easy way to solve this problem ? I was using Rows but they changed the way they update which is not working now.

Regards

[Simo]

Hello

Are the properties shown in the screenshots inside the “Properties” collection or the “Properties values” collection in the output?

They look like from the “Properties” collection, which provides the data structure of the database rather than the actual data. If that’s the case, try expanding the “Properties values” collection and see if you get the formula values there

[caporali]

Hello, I did already check “properties values” but looks exactly the same.

Thanks

[Simo]

I am not sure why this is happening - two things I would check:

1. If the formulas use inputs from related databases, does the connection have access to those related databases?
2. Do the formulas have a well-defined output type (e.g., number, text, block, checkbox, …) or are they mixed-type?

[caporali]

1 / Yes, I juste chekced.

2/ Not sure about question 2. I am referring to couple formulas and the problem applies to each of them. Each formula has indeed a well defined output. On Notion, they are (here is the screen shot of one of them on Notion. They also imply relation and roll up

Also a capture of my scenario on make, I can give you access if you want.

Regards

[Simo]

For #2, I mean do you see “number” next to “0” if you click on the eye icon highlighted in the screenshot below?

[caporali]

it is number next to the pictogram.

[Simo]

Got it - in this case I don’t know why your formula properties in Make don’t show the value. It could be related to the use of rollups as formula inputs, but I am not sure. I would need to allocate time to investigate further. Apologies for not being helpful here

[caporali]

Yes, let me know when you find it.

Thanks