Is there a way of transferring data from one field to another? I haven’t spotted any function that will merge or concatenate data from different fields. But is there any way of exporting and reimporting data that would permit this?
Hello Nomolo,
There’s no function to copy data from one field to another.
But to merge data, you can create a Calculation field and concatenate the fields together using a formula such as:
[First Name] + ” ” + [Last Name]
Make sure you set the Return Type of the Calculation Field to Text.
Thanks,
Brendan
Thanks Brendan – that’s terrific!
Brendans solution is nice but in my case Tap Forms 3.0 doesn’t seem to like it:
as long as the default layout is used it works as expected, but in a home-made layout the outcome of the calculation is 0 (zero). Very disappointing. I struggled with this behavior before and had just planned to send a bug report to Brendan, but as a follow up of this thread I tested it in a simple new form with only a first name, a last name as text fields and a first+last as a calculation field. See the screenshots for the results with typical Dutch names ;-).
Could it be a bug or do I miss something??
Regards, Rudy.
Attachments:
You must be
logged in to view attached files.
I actually fixed this bug on the custom layouts just tonight.
What I find strange though is the detail record has some odd colouring. It looks like perhaps a Mavericks issue. I don’t see that on Yosemite.
Thanks,
Brendan
.
