JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can't Seems to Get A Hold of API SupportAsked by onefootprod on May 20, 2014 at 12:52 PM
I have tried a couple times to get a hold of the support team for the API (firstname.lastname@example.org) with no luck. Can you help? Below is my question:
Hi there.I am having trouble using the sorting feature on the API. Here is what I am doing. Can you help?$submissions = $jotformAPI->getFormSubmissions($formID,0,0,"input_27”);Also, is there a way to change descending vs ascending?Thanks, Kevin
I'm sorry about that. I have a feeling that it is likely because some of our developers whom are in charge of helping with API have probably been busy with various other assigned projects. I am pretty sure they did not mean to ignore you and would have responded back about it as soon as they could.
Are you trying to have the form read and sent somewhere to be sorted and ordered in a controlled submissions listing for a certain field then? or?
Can you explain more about your intentions for sorting and the order? I see what you have, but I am trying to figure out more about exactly what you are needing since it's a little hazy.
We use JotForm to have people enter the information, but we then use the API to fetch the results and create a custom summary page. We would like to be able to filter and sort this summary by different fields.
I think that the orderby parameter is designed for ordering based on system fields such as created_at, updated_at, flag, and so on. I am not quite sure if we can order by question ID, so I have attached a ticket to this thread. Also, it seems that ascending / descending sorting option is no available at this moment.
We will get back to you when we have any news on this.
getFormSubmissions method gets five parameters which are form ID, offset, limit, filter and order by. You can sort your form submissions by questions IDs. All you need to do is give question ID to getFormSubmissions method as last parameter. Your code should look like this,
$submissions = $jotformAPI->getFormSubmissions($formID,0,0,null,"input_27”);
Hope this helps.
If you have any other quesions please let us know.