I have the settings in my workspace for my Euro currency to display a comma instead of a dot. But when I want to show it in the Name field using a formula, it shows with a dot.
I’m not sure if this is a bug or if I’m doing something wrong. This is crucial for me to pair the transactions with my invoices.
Thanks in advance!
Tricky, as the workspace setting is just about how it shows the UI, and not about the actual data.
If its just replacing the decimal with a comma, you can use this formula: Replace(ToText([Number]), “.”, “,”)
But if you also want the separators every 3 digits, thats gonna be a bigger pain…
Could be useful to have different formats in the “ToText()” function at some point in the future.
That said, if this is crucial to your workflow, there may be a workaround where this isn’t needed. If you would like to share more about how this fits into the flow, I could try suggesting something.
Thank Ron! Maybe the ”replace” formula will work….I use it to match transaction on the relation field. So I can search for the amount…
When you say match, is it an auto-linking match? Or just for you to see it? Why not have it match based on the number field?
If I understand correct, you search for them in a select dropdown, and then it only uses the name, so you need to search by the amount? Is that right?
Having relation filters be able to compare dynamic values and not just relations would be ideal here.
You COULD build a workaround where it makes an entity with that value if it doesn’t exist, and it links to it if it does exist. It does the same in both the transaction and the invoice. Then in the dynamic relation you filter that it is “This Transaction → Amount”. Then it will suggest invoices that have the same amount as this transaction, and then you could also sort by creation date.
If you’d like to find a time to build together, it could be a nice episode of “Fibery Live Support” :)) No pressure though.
Ron, I have tried auto-linking, but it does not always work because some amounts are the same. This is a “Bank DB” relation that I need to link to my “Expenses DB”. To one to one relation.
If by creating a value you mean an entity, I would not want to do that, since I don’t want to modify the bank DB.
(By the way! Filtering “files” trick worked perfectly! Thaaaanks!!! 
. )
Makes sense!
Sounds good. But I was curious about if my idea would work, so I went ahead and made a little mock up, if you find it interesting:
Like this you could even combine it with auto-linking, where if auto-linked (amount and date) is only one expense, link it automatically. this way it will link the ones that are certain, and leave the uncertain ones for you to fill by hand. Possibilities are endless!!! :))
https://shared.fibery.io/t/df65c55c-a300-4d0d-b1c0-9351c617a654-eva-banking
Thanks, Ron! Looks really interesting, I will take a look!
Not sure if it’s worth it for me to maintain such big infrastructure, since I don’t have a lot to match normally. It’s just for now, that I’m importing all my database from Coda, and I needed a way to be able to find them for the moment being!
Yes, formulas on Filters would be AMAZING! 