Forum Discussion

AngelaAnderson's avatar
AngelaAnderson
Qrew Member
2 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's avatar
AhuvaBrown
Qrew Trainee
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's avatar
AngelaAnderson
Qrew Member
2 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
------------------------------