I wrote a while ago that formulas with WithName() and RunActions() were buggy.
Well I think they still are.
I’m getting many Cannot convert value to specified format errors.
I wrote a dummy doc bellow to show my case.
I created a formula that copies data from one table to another and it marks the source data as archived.
I’m quite aware that WithName() can be omitted in this formula. Please, understand that this is a dummy doc. My real case is more complex;
Hi, @Pch .
Thank you for your help.
I’ve just found another issue.
If Date column in Source table is blank, you get the same error. This can be “fixed” using .IfBlank(""), still it’s a very odd behavior.
The problem is I understand why you insisted on letting us know that this is just a dummy doc and you know WithName() can be omitted here but suppressing it from the formula does seem like the actual solution… at least to get rid of those inconsistencies
Now as you also said that your use case scenario is more complex, maybe you could try to contact the support directly, through Intercom with your actual doc ?
(So they could take a look at what you’re effectively trying to accomplish with WithName() here)
I mean, without knowing why you really need your button to work the way it does (in the dummy doc) it’s a bit hard to help you debug it …
I’m sorry, once again, to not be of much help here