Concatenate

[Fre3]

Is there a way to concatenate something from 1 table to another table? 

[Rafael_ANEIC-PY]

Hello @Fre3, anything can be done, but I'm not sure what it is you want to concatenate exactly, how or where, could you make a couple of specific examples?

[Fre3]

I'm wanting to take what I've highlighted in red and put in in the view I've created but I want to do this for every row so the phone number corresponds to the correct person

[Rafael_ANEIC-PY]

I believe you want to dereference a contact phone number using the contact ID? you could to that by using a expression like this one:

[contactID].[title]

You can read more about dereferences here:

https://help.appsheet.com/en/articles/1090811-dereference-expressions

[Fre3]

Column 'Contact number' in Table 'tbl_prices_Schema' of Column Type 'Ref' has an invalid expression in the Formula field.'=[contactID].[title]'. Error in expression '[contactID].[title]' : Unable to find column 'title', did you mean 'active'?

[Fre3]

The numbers are in a separate table to where I want them to go 

[Rafael_ANEIC-PY]

Can you share a screenshot of your "Contact" table where [contactID] is the key value? the contact number should be located there in order to make a dereference.