How to use Search a Record kintone with Lookup Field

Questions
, , ,
1

:bullseye: What is your goal?

Hi,there
I would like asking about how to setup Search a Record module of Kintone.
i try to setup query by :

  • Lookup <—it’s field code in kintone and field type is lookup
  • comparison operators =
  • text parser value (get from text parser module)

and i got error 400

:thinking: What is the problem & what have you tried?

I try to use field code , field name , use “” and it’s doesn’t work

3

Hey @Wutisak !

The query is not valid because lookup fields in Kintone cannot be used directly with the equals operator in that way. The lookup field stores data differently and is not queried as plain text.

You need to use the actual underlying field that the lookup is referencing, not the lookup field itself. In the query, use the field code of the source field from the related app and match against that value.

Make sure the value is wrapped in quotes if it is text, and that the field code is exact.

Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard