Convert LongText to Address

[stephenrich]

Dear Appsheeters,

i have a table named [Vendor]. It has column named [Ven_Address] as LongText.
Can I display it as Address using Virtual Column?

I tried to create a new Virtual Column named [VC_Ven_Address] as Address, with Expression : [Ven_Address]
my Action Button (View Address) wont show even if i have set the [VC_Ven_Address] type as Address, with the right expression.

Please advice.

Thanks.

[Suvrutt_Gurjar]

Please ensure you have included the [VC_Ven_Address]  as "column to attached to " and set it as an inline position in the system action created by the app.

[stephenrich]

I did, Yet still not showing.

The real Address Field is [Ven_Address] which is a LongText data type, since I need it to be long and multi line address so we can use it later in Documents and Mailings.

While the virtual is [VC_Ven_Address] which is an Address data type for enabling it to be viewed in map. Below is the column details.

[Suvrutt_Gurjar]

Did you try setting up long text column itself as an address column? Are you facing any issues while doing so?

[stephenrich]

Yes I did, previously my address columns are in Address Type. But as I mentioned before, I don't like the single line address to be put in my pdf documents like invoicing and mailing. So I need to make it multi lines by changing it to LongText. And try to create a virtual column that change back to address so it can be detected in Maps.

[Suvrutt_Gurjar]

I think my suggestion was to test if long text column itself works as address or not, just for testing purpose.

If the original column itself is not working with Address setting then you will know the problem is there.

BTW in my testing when a long text column  with address was used in expression  into a VC type address column, it worked for me.  I mean the address type VC column had action as well as it appeared in maps. I, however did not have multi line split the way you mention.