Friends, I've been trying to get this right f...

[erwin_blom]

Friends, I’ve been trying to get this right for days. I hope someone can help!

This is the case. I’m building a tour app for the band of my children. I’ve got on sheet with the tour date and a column called hotel with the names of the hotels. I’ve got another sheet called hotels with a column called hotel. Appsheet makes the connection but gives an exclamation mark on the page. So something is wrong. But what? Hope someone can help!

[Simon_Robinson]

When that’s happened to me before I think its because the content of that cell is invalid somehow

[Sdfaheemuddin]

I guess your column type for hotel is ref. In that case if you don’t have the same key (“Stylish Apartments” in this example) in reference table then you get this error

[Sdfaheemuddin]

I guess, column type for your column hotel is ref.

In that case, you need to have a key “Stylish Apartments” in the reference table.

This error shows up if you don’t have the key in ref table

[erwin_blom]

@Sdfaheemuddin Thanks! This did the trick!