ContributionsMost RecentMost LikesSolutionsRe: how to get the latest records first from quickbase in API_DOQUERY Use the Sort Order Option on API DO QUERY in order to get latest. sortorder-A --specifies an ascending order. sortorder-D --specifies a descending order. Tip:To sort on multiple fields, simply add more A's or D's onto the sortorder option: sortorder-ADA will sort ascending by the first field in the query, descending by the second field, and ascending by the third field. nosort --returns unsorted records, ignoring the sortorder option, the slist parameter, and the default sort for the table I hope this will work.Can we filter Multi select Text on basis of record ID.I have a table name feature that contains id and value. Let's say. 1 - A 1- B 1- C 2- D 2- B 2- A Second Table name Project. I want to create a multi-selecttext box where I can pull feature table data w.r.t to Project ID. means - this multi-selectwill show A B C As this belongs to project ID 1.Re: How do I make a Common report read-only (non-modifiable)?See picture attached in order to set Records for view mode, not editable. This Section is availableinside report. .Re: Using an ""Unknown"" option in a User List.I think we can approach in this way also. What do you think? 1- make this field not required. 2- Whenyousave a record without entering the value in this field at that time Fire a webhook and see if the field is blank. If it is blank fill it with the default value.Re: Using an ""Unknown"" option in a User List.Creating unknown user it's like wastingyour user licenses.Re: Using an ""Unknown"" option in a User List.I didn't find the option to add the value 'UNKNOWN'. but w/o using license how I will approach. 1- make this field not required. 2- Whenyousave a record without entering the value in this field at that time Fire a webhook and see if the field is blank. If it is blank fill it with the default value. I hope this will work. Thanks,Re: Using an ""Unknown"" option in a User List.What is the field type?Re: Sorting a Summary ReportGo to sorting section below and select Custom Order. Select Sort By and from high to low. See Picture Attached. Thanks Re: Need to refresh first then, approve the leave applicationYeah Sure, Step 1 - Make API do query call in order to get all your projects or application whatever you say along with the RecordID. 2- Display in a table associated with the check box. 3- Then on click of button check how many checkboxes are selected if none leave error message else, Suppose two check boxes are selected get theRIDfor these 2 check boxes and store in an array. 4- loop through that array in order to make API EDIT Record w.r.t individual RID. 5- Done. see attached picture for better understanding. Re: Need to refresh first then, approve the leave applicationGoing in every application and then approving looks tedious. Assume you have more than 4 and for every application, you want to approve leave application. Why not create a custom script that allows you to update all application on a single click. - create a page showing all your application along with a checkbox. - which ever checkbox is checkedcollect rid for that checkbox and write API edit record in order to update leave taking balanced w.r.t rid you collected. let me know if this solution looks good to you. It will save a lot of time.