Multi item select for form input

App Development
1

Hi, hopefully someone can help me out here. I have a table that I need to add multiple products from a particular supplier. This creates an order template for the user. The big time waster is having to add the Supplier name & the product, save the form then start the process again. If the template has 30 items from a supplier that is 30 times I need to save the form. Is there a quicker way to create the template? ie an option to select multiple products at once? Cheers

2

@brad why not start doing it in an excel then import that excel once done on Tadabse?

3

Hi @brad

I have created a solution that may help you, I will try to explain one of the methods I have implemented below:

  1. In Users table, add connection to Orders table (or the table where you store the selected products)
  2. Add New Order Page, using javascript, auto save it & update the User with the new order, and finally redirect to Edit Order or Detail page
  3. From Edit/Detail Order page add Products table
  4. In Products table add Edit button, this will show the selected product, using javascript you will auto save with Insert to connected table and this will add +1 of the selected product into the Order from the selected User. And finally auto close the page.

Hope this makes sense and it gives you some idea.

4

Hi @manuelchhjny, Excel isnā€™t a good solution for users. These order lists will need to be created by users periodically & having to do it in a sheet then save as CSV then import is a pretty horrible way to interact with the app. Simply being able to multi select items to add would be much better. But if it canā€™t be done without resorting to JS I may be left with no alternative. Cheers

5

Hi @sahiraz thanks for the feedback. I will give this some consideration. Do you have any JS code for the autosave? or is in the help docs/tutorials? Cheers

6

Yes, I agree on that.

7

@brad
// Auto click of Button ā€œSave & Updateā€ once loaded:
// ***********************************************************************************************
var onLoadEditProject = false;
// alert("Here you are : ");
function forceSubmitEditProject()
{
if(onLoadEditProject === false)
{
if ($(ā€™#x_element_page_106_3 .form-submit .af-form-submitā€™).html() !== undefined)
{
onLoadEditProject = true;
}
window.setTimeout(forceSubmitEditProject, 100);
}
else
{
// alert("Here you are : ");
$(ā€™#x_element_page_106_3 .form-submit .af-form-submitā€™).click();
}
}

TB.render(ā€˜component_3ā€™,function(){
forceSubmitEditProject();
});

// End of : Auto click of Button ā€œSave & Updateā€ once loaded:
//***********************************************************************************************

Replace x_element_page_106_3 with your pageā€™s element id

image
image1359Ɨ375 45.2 KB

Replace component_3 with the component info from the page builder
image

1 Like
8

Thanks for the code. I will see if I can use it to help me. Thanks

1 Like
9

@moe Is multi item select/add an option being considered? I would love to see the ability to quickly add records associated with the same connected record. For example, add serial 1, serial 2, serial 3, etc connected with Company A. This would be done within 1 form and allow you to add line items. This would allow rapid entry of items without having to resort to cumbersome CSV import.

3 Likes