How to fetch data from a autolookup in a text field

Follow

Suraj Mitra

• February 06, 2020 11:17

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

0

• 

  Alexey Shmelkin (sysberry-absc.com)

  • February 06, 2020 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

  Comment actions Permalink
• 

  Suraj Mitra

  • February 06, 2020 12:44
  • Edited

  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

  Comment actions Permalink
• 

  Alexey Shmelkin (sysberry-absc.com)

  • February 06, 2020 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

  Comment actions Permalink
• 

  Suraj Mitra

  • February 06, 2020 12:46

  Thanks a lot

  0

  Comment actions Permalink

Please sign in to leave a comment.