Fill a Form From a Product ID

[djbginns]

Hi I am looking for a quick and easy way to fill form details from a product ID 

Example: Product ID comes from a reference table 

I want the corresponding information to match from the two tables 

Database:           Form:

Unit Price :     Unit Price 

Tax :Tax  

Description : Description 

Would this be a select formula ?? Please let me know. 

Thanks,

Brendan 

[Marc_Dillon]

Maybe a dereference?

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

[djbginns]

Perfect! that worked great, do you know if it is possible to have two different REF tables and run if one of the two is selected? Or would I have to make new coloums for each ?

For example:

Table 1 : Supplier Prices  - Table #1 

Table 2: Supper Price 2 - Table #2 

Form 

REF : Product ID - Supplier 1

REF: Product ID 2 - Supplier 2 

[Marc_Dillon]

https://help.appsheet.com/en/articles/2355953-if

https://help.appsheet.com/en/articles/2355961-ifs

https://help.appsheet.com/en/articles/2357266-isblank

[TedM]

---

---

@Marc_Dillon wrote:

Maybe a dereference?

---

So how would a dereference differ from a Lookup?  Wouldn't that also work?

[Steve]

---

@TedM wrote:

So how would a dereference differ from a Lookup?  Wouldn't that also work?

---

Same. Yes.

[TedM]

Thanks Steve - just checking!

[djbginns]

Ok great, 

Thanks guys, 

Would a dereference work with a last item? for example I want to pull the last information from a User into a form 

=IF(USEREMAIL(),="email@gmail.com), [Last_Item]. [Time] 

How would I structure it if I just want to show the last item of the user that is actively using the form? 

Thanks 

[Steve]

How do I get a column value from the last row of this thing only?

[djbginns]

Hey Steve, 
i have been trying to use a dereference with the expression above, but it doesn't seem to work. do you think you can help me fix it ? 

Is it a problem if the SKU# is a REF to another table? 

LOOKUP(
MAX(
SELECT(
Inventory Count Master[Sku #],
([_THISROW].[Cases] = [Cases])
)
),
"Inventory Count Master",
"Sku #",
"Cases"
)