ContributionsMost RecentMost LikesSolutionsWhat is best practice making custom pages to access multiple tables?Can someone point me in the right direction I want to know best practice for creating a custom QB page that gets data from multiple tables and can edit. It will be opened on an Ipad with the QB app. I don't see any recent libraries to help do this, so I think I'm missing something. Do most people create a html page with embedded javascript and use ajax to get/update data from tables using get string queries? Or is it more complex using json api and dom updates.? is there any tutorials on this? Or any resources that you know of that may help me understand? thanks ------------------------------ Johnny Niumata ------------------------------ Re: Kanban vertical sortinggotcha... I just tested adding in more records and it automatically created the sort order number by incrementing to the previous sort order number within that kanban column (in my case "work ticket status" is the column). here is a response from the table in JSON { "data": [ { "25": { "value": "WC1.01" }, "72": { "value": "Not Started" }, "75": { "value": 19.9 } }, { "25": { "value": "CAS1.01" }, "72": { "value": "Casting and Shipping" }, "75": { "value": 30 } }, { "25": { "value": "JAM1R.01" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.701 } }, { "25": { "value": "SSK2.01" }, "72": { "value": "Mold Dept" }, "75": { "value": 60.2 } }, { "25": { "value": "SSK2.02" }, "72": { "value": "Mold Dept" }, "75": { "value": 60.1 } }, { "25": { "value": "SSK2.03" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.60000000000002 } }, { "25": { "value": "UB1.0" }, "72": { "value": "Not Started" }, "75": { "value": 21 } }, { "25": { "value": "UB2.0" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.50000000000003 } }, { "25": { "value": "JAM1.01" }, "72": { "value": "Not Started" }, "75": { "value": 90 } }, { "25": { "value": "KS1.1" }, "72": { "value": "Not Started" }, "75": { "value": 100 } }, { "25": { "value": "PAN13.1" }, "72": { "value": "Not Started" }, "75": { "value": 110 } } ], "fields": [ { "id": 25, "label": "Part number variant", "type": "text" }, { "id": 72, "label": "Work Ticket Status", "type": "text-multiple-choice" }, { "id": 75, "label": "KanbanPriorityOrder", "type": "numeric" } ], "metadata": { "numFields": 3, "numRecords": 11, "skip": 0, "totalRecords": 11 } } ------------------------------ Johnny Niumata ------------------------------ Re: Kanban vertical sortinggood idea to use formula numeric. I'm new to quickbase, so not sure when to use the correct method. is there a way to change formula so that if it is empty or zero to set the value to a high number so that non-sorted items are lower in the order? ------------------------------ Johnny Niumata ------------------------------ Re: Kanban vertical sortingI know this is an old post, but since I found a new solution I thought I would share. when you enable sortable kanban on a table, a hidden field is added to that table. The hidden field is called "KanbanPriorityOrder", and the order is saved in this hidden field as a number. Unfortunately since it is hidden, you cannot order reports on this field, so we have to copy it to a newly created field. my solution requires 2 main steps. 1. adding a new numeric field to a table (eg. kanban-sort-copy) , (I manually set all existing records to value of 1000) 2. using a webhook to copy the kanban sorting order into this field, whenever sort order is changed. I will only talk about step 2 here is my webhook (API_EditRecord) <qdbapi> <udata>mydata</udata> <usertoken>%user.token.xxx_xxx_xxxx.testingJohnny%</usertoken> <apptoken>[xxxxxxxxxxxxxxxxx]</apptoken> %RepeatOn% <rid>[Record ID#]</rid> <field fid="77">[KanbanPriorityOrder]</field> %RepeatOff% </qdbapi> I manually typed in the [KanbanPriorityOrder] after I found it's name using the restful API (it does not show up in the dropdown of fields) field 77 is my new numeric field that I created. this webhook looks for all updated records and then copies the kanbanPriorityOrder to the new field. Now I just sort reports using my new field. so far it is working well for me. ------------------------------ Johnny Niumata ------------------------------