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

  评论操作 固定链接

请先登录再写评论。