Concatenation in Macro

Open discussion about our Alloy Navigator 6 application

Concatenation in Macro

Postby trc_pdx on Fri Oct 29, 2010 10:44 pm

I'd like to populate the value of a field on a form based on the concatenation of the values in two other fields. Thought I might be able to define a macro that concatenates the two other placeholders. If this is possible I haven't stumbled onto the right syntax. Any ideas? Thanks!
Posts: 11
Joined: Thu Sep 23, 2004 9:59 am

Re: Concatenation in Macro

Postby eliaslynch on Tue Nov 02, 2010 11:20 am

going off of memory, but isn't syntax like this?

Code: Select all
%[Assignee_ID].[Last_Name]%+ ', ' +%[Assignee_ID].[First_Name]%

doesn't that work? I see macros support full SQL queries now so can't imagine it won't work.
User avatar
Posts: 212
Joined: Wed Jul 09, 2008 7:03 pm

Return to Alloy Navigator 6 Discussion

Who is online

Users browsing this forum: No registered users and 2 guests