How to get fid dynamically from UI?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hi ,

I have created a report which is showing data  in Table format on Click of Button,for this i have created a query which has hardcoded value as below:

QB_url= projectsTableID+"?a=API_DoQuery&query={6.EX.'INDIA'}&clist=27.6&fmt=structured&cache="+noCache;

but the enhancement is to make it as dynamic by creating control on HTML page and on click of button it should display records accordingly.

for that i have created textbox and allowing user to enter columns name and for the entered column name i need fid so that i can append it with Do_query and on click of button i can fetch the records for these columns only.

Could you please guide me in getting fid dynamically.

 

Thanks ,

Sushma

 

Photo of SUSHMA

SUSHMA

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
On your HTML form you will need to manually construct a <select> associating the displayed field names and the fid values along with appropriate logic to construct the URL after a selection is made.

<select ...>
   <option value="1">Date Created</option>
   <option value="2">Date Modified</option>
   <option value="3">Record ID#</option>
   <option value="4">Record Owner</option>
   <option value="5">Last Modified By</option>
   ...
</select>