Hi,
just got Tapforms and managed to import our old bento template and data, and got it syncing over the office network.
my quick question is.
Is there anyway to merge to text fields?
thanks
nigel
Yes,
create a calculation field and set the result to text.
In the formula you can drag the fields you want to merge…
<field1> + ” ” <Field2>
the ” ” create a space between the fields to merge if you want that.
Thank you i will give it a try first on a dummy database
Nigel
Hi leo,
this did what you said however as a calculated field it will not allow me to delete the fields tai know longer need. I was hoping to tidy our database by merging a couple of fields and deleting those no longer required.
thank you anyway for the help
Nigel
Sorry, but that is not possible.
Leo
But…
You may try a complete export tos CSV or excel with database – record ID
Then edit the required fields and import that back. Leave the ID Fields intact. Also the redundant fields, delete these after the import in Tapforms.
Try with a dummy database first.
OK thank you I will try that.
Nigel
You could also switch to the multi-column list view, then select the column for the Calculated field, then press command-c to copy. Then create a new Text field, click on the first cell of the first row in that column, then paste. Now you’ve got the combined value from the two fields into a third field (via the Calculation field).
.
