How to fetch data from a autolookup in a text field

追蹤

Suraj Mitra

• 2020年02月06日 11:17

The output of this query i need to show this in a text-box. Please suggest me how to do ,asap.

0

• 

  sysberry GmbH

  • 2020年02月06日 11:35

  Hi Suraj,
  you need to cast the column to the internal name of the Text Box like: select Field 'tbFieldInAgilePoint' from Table where ...

  Make sure, that you use muliple value type of lookup.

  Regards,
  Alexey

  0

  評論操作 永久連結
• 

  Suraj Mitra

  • 2020年02月06日 12:44
  • 編輯於

  Hi Alexey,

  Yes I am using multiple column.

  The internal name of my text box is 'Count', could you please provide the complete query, as given in the picture, for me?

  As well as could you please provide me the javaScript function to fetch the value auto lookup?

  Regards

  Suraj

  0

  評論操作 永久連結
• 

  sysberry GmbH

  • 2020年02月06日 12:42

  Hi Suraj,

  Query: select count(*) 'Count' from AccountPayableInvoice__u where <your where clause>

  The value will be mapped to the Count control automatically (because of the internal name), no need of JS.

  Regards,

  Alexey 

  0

  評論操作 永久連結
• 

  Suraj Mitra

  • 2020年02月06日 12:46

  Thanks a lot

  0

  評論操作 永久連結

請登入寫評論。