Default cannot be converted to number

[pokhani]

hi Expert, 

after recent update on 365, there is an error in default portion. 

previously it was working fine

[RandyHayes]

@pokhani 

What type of column are you working with?

In general though, your formula should be: Coalesce(ThisItem.yourColumnName, Last(Forecast).UniqueID+1)

This assumes that your column is a numeric column.

I hope this is helpful for you.

[pokhani]

hi 

Thank you for the reply. but what about the if condition. 

regards

[RandyHayes]

@pokhani 

The if condition is most likely not needed.  Isn't your ultimate goal to provide a value if there is no value (i.e. a New Form)?  If so, then the only formula you need is: Coalesce(ThisItem.UniqueID, Last(Forecast).UniqueID+1)

[pokhani]

no the ultimate goal is to increase the uniqueid column with +1 if its new request. 

[RandyHayes · Accepted solution]

@pokhani 

Correct, but that is a different point.  

What I mean by the main goal is from the field perspective.  If the field is empty (i.e. a new form), then it gets assigned the next id.

Are you dealing with editing records (not creating new) that will have NO id in them?

[pokhani]

yeah i got it, i fixed it, adding parent.default 

and in update adding value