Hi,
as Tap Forms now includes table fields I tried another time after some years to switch over from Bento. I have one customer, project and invoice database with several thousands of entrys.
Transfer from Bento was okay, just no layout.
But:
There is a huge number of empty cost calculation fields – options not used by customers. This prevents any sum calculation in Tap Forms.
Question:
Is there a way to set empty number fields to Zero in calculations?
Impossible (and stupid) to fill them all with zeros. So in the moment still no working transfer from Bento for me.
Hello MMM,
The transfer of the Calculation field type from Bento to Tap Forms is not a perfect translation. You’ll just need to edit the formulas for the Calculation fields and make them correct again.
To return a 0 for an empty number in a Calculation field, use the IFEMPTY() function.
For example:
IFEMPTY(Price; 0; Price)
What that means is if the Price field is empty, then return a 0 value, otherwise return the actual Price value.
Hope that helps!
Brendan
Thanks for the answer.
I tried a different approach: Search für empty fields in a row and fill them with zeros. But this went wrong – and there was no undo! I investigated further and it seems there are a lot of actions which have no undo! Make mistake and you are dead.
This is horrible and not akzaptable for me, because every mistake or false entry can cost a lot of money. Its my acounting database. Every (!) action must be undoable! In Bento deleting the whole database is undoable.
Still waiting for a more stable version…
.
