Begginner issue: Why cannot appsheet see the data even if it's inserted from data explorer?

[vaiari]

OK a Newbie here, though I've made an appsheet app many years before. I wanted to dive in deep but stuck at the essentials. It might seem stupid, but on the image you can see the arrow where I clicked on insert and you see what it says above. This app is a clone of IT Ticketing sample from appsheet. Similar things happened like "cannot find column 'Technicians' do you mean 'Technicians'?" any link you may suggest reading?  What I am trying to do here is get the Name value from the source sheet technicians, where 'name' matches 'email' row and hopefully on my next step of the expression : matches the useremail() . To put it another way : I want to bring the Name field from the Technicians sheet (or table should I say - it's a bit confusing here) using useremail() .Thanks in advance.

[Joseph_Seddik · Accepted solution]

[Technicians] in your expression is a name of a column not a table. You have to do some revisions 🙂 but it's easy.

Just read these guides please and you'll easily get it:

• Data: The Essentials - AppSheet Help 
• References between tables - AppSheet Help 
• Dereference expressions - AppSheet Help 

[MultiTech · Accepted solution]

Yeah that data explorer thing is a little wonky.

It's a great idea, but like..... deployed at 68% functionality.  🤣

--------------------------------------------------------

Honestly I think you're better off NOT using that thing to insert your column names

• instead go to your data source and just copy the name of the column
  
  
• Boom... done.  No typos, no issues, no wasted time.  
  • Click click click (to get to the sheet),
  • copy,
  • click back to the app,
  • paste. 
  • Done

[Joseph_Seddik · Accepted solution]

[Technicians] in your expression is a name of a column not a table. You have to do some revisions 🙂 but it's easy.

Just read these guides please and you'll easily get it:

• Data: The Essentials - AppSheet Help 
• References between tables - AppSheet Help 
• Dereference expressions - AppSheet Help 

[pravse · Accepted solution]

Hi @vaiari , you might want to try the LOOKUP() function for your specific purpose.

[MultiTech · Accepted solution]

Yeah that data explorer thing is a little wonky.

It's a great idea, but like..... deployed at 68% functionality.  🤣

--------------------------------------------------------

Honestly I think you're better off NOT using that thing to insert your column names

• instead go to your data source and just copy the name of the column
  
  
• Boom... done.  No typos, no issues, no wasted time.  
  • Click click click (to get to the sheet),
  • copy,
  • click back to the app,
  • paste. 
  • Done

[vaiari]

Many thanks to @Joseph_Seddik @pravse @MultiTech . There's for sure something's glitchy.