Error with Formula field Contatenating ID

Bugs
1

Hi there,

We’ve come across an issue with the result of a formula field we created.
It appears to occur when new records are added to the table in question - the formula is not displaying the expected result for these new records.

The formula concatenates the table ID with other values in the same table. Formula is below:

image
image747×456 22.1 KB

Below, you can see two new records where the formula is result is not displaying the ID (these should start 'R186 and R187) instead, only ‘R’ is displayed.

image
image218×729 24.4 KB

2

Thanks for bringing this to our attention - it only occurs on creation is that right?

3

Hi Daragh,

Yes, whenever a new record is created the formula does not appear to update correctly/display the expected result.

Cheers.

1 Like
4

We’ve flagged this with the team - we’ll keep you posted

In the meantime, you could maybe calculate that value with a workflow?

2 Likes
5

Will try your suggestion Darragh. Thank you.

6

I have what I think is a related issue, I’m creating records via Make/API and I have a linked record field which should automatically link, however when new records are created they aren’t automatically linked up. But when the records are updated the automatic link then kicks in.

7

Have you considered linking based on uuid @EthosLuke ? I think that would solve your problem

8

I can give that a shot, they’re self-linking records (parent & children) so I’ll need to ensure they’re created sequentially and then will need to do a search for the parent record to obtain it’s uuid…

My only concern is that I get frequent operation timeouts with the Noloco modules in Make so I’m afraid my scenario won’t be able to run for long enough!

1 Like
9

Hi Darragh,

Just wondering whether there is any update on this? Or, approx. when we can expect to see resolved?

Thanks.

10

Hi @cizict - we hope to have this fixed at the start of this week coming.

Thanks for your patience.

We will keep you posted

11

Hey @EthosLuke and @cizict

This issue is now resolved.

Using the ID field in your formula’s will now work when new records are created

2 Likes
12

Thanks Darragh. Tested that and all appears to be working as expected.

1 Like
13

Hi @darragh,

I have a formula field that creates a link based on the uuid of a record. When new records are added, the uuid returns [object Object] and therefore I cannot open the link. You can check the record named “2024/09” from the following link:
https://gintekik.noloco.co/periods
The record buttons for other records work fine but for newly added records it fails.

I hope you can resolve this as well.

Thanks.

1 Like
14

Thanks @ardaergin for bringing this to our attention, the team have started rolling out a fix for this, it should work as expected within the next 30 minutes

1 Like