Forum Discussion

Qrew Member

3 years ago

Help with GetFieldValue(GetRecords....to lookup value in another table

I want to pull a value from one table based on a field in another table. I have a summary table with raw material prices, lets call this table B. each entry is for a different month/year, so this fi...

formula queries

AhuvaBrown

Qrew Cadet

The result of the GetFieldValues formula is multi-select text, so it has to be converted to the data type of the field it's in (unless it's already a multi-select text field). So if it's a text field, convert the formula to text:
ToText(GetFieldValues(GetRecords("{16.EX.'"&[Date]&"'}","tableB"),25))

------------------------------
Ahuva Brown
------------------------------

AngelaAnderson

Qrew Member

3 years ago

Just tried that. It lets me save the field, but the entire formula is underlined in red and now says expecting number but found text.

When I look at the value on my table for RM A cost I am getting a value of 0.

------------------------------
Angela Anderson
------------------------------