How to get the fields of a user in a table that are meant to be added or edited using API?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I require the fieldIDs of the fields that a displayed when you press the addRecord button against a table. API_GenAddRecordForm only provides me an HTML page for the same but since I am building my own native interface I require the fieldIds before I call the AddRecord or EditRecordAPI so that I get the exact page as displayed in the web in the native interface through API call.

Please see the screenshots below. I have a client table (data for this is obtained from DoQuery) and an Add Client button that leads me to the Add Client page with three fields to add data. Is there any way to identify these three fiends through the DoQuery or via any other API. I require the fields that are displayed in the AddRecord page via an API call

Photo of Sreekumar

Sreekumar

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
If you go to the table and then Fields you will see a field list.  There is an advanced options icon at the top right and that will let you display the field ID's for each table.  Also the "Usage" tab for any field shows the field ID or actually hovering over the field on the list does as well too.

If you wanted to pull the whole schema for a table by an API call, you can use the API_GetSchema will return the fields and their field IDs.

http://help.quickbase.com/user-assistance/Default.html#apicalls.html
Photo of Sreekumar

Sreekumar

  • 0 Points
I know what you mentioned is possible through the Web. Accessing the FieldIDs from the web is not usable for me as I'm trying to build a native UI on iOS for the AddRecord page entirely via API calls. I'm trying to access the FieldIDs through the API. Not the entire FieldIDs but just the ones displayed in the add record web page. Im already getting all the fieldIDs for a particular field through DoQueryAPI.  As shown in the screenshot example, there are 5 fields in the table but only 3 fields in the add client page. How can I distinguish these values from the DoQueryAPI or is there any other API that I should be using?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Are you saying that you are trying to be a general iOS interface which will work with any Add Record page?
Photo of Sreekumar

Sreekumar

  • 0 Points
Yes I am building a native AddRecord page to work with any AddRecord page that is why I require the information on which Fields to display on that page.
Photo of Sreekumar

Sreekumar

  • 0 Points
Kindly provide me a solution to this as soon as possible. It is highly essential that I incorporate this functionality in my app as soon as possible.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Sorry, but I don't know the answer to your question.