hi all,
my design contain a data repeater which show products entered by the user includes its specs like name, Qty, Description etc, which also saved in a data table “Temp products”.
when user click button “Save”, these products in the repeated container to be saved as a list in another data table “saved products” with a relationship to another data table which is “customer savd lists”, the relation status is One “saved list” yo many “saved products” and delete the products in the first tabe “Temp Products” in one click, is that possible?
Hi @Sherif_elmokadem
Welcome to our community and thank you for trying out Backendless.
In Backendless, there are many possibilities for implementation, and the case you’re interested in doesn’t seem impossible. We have features like Deep Save and Transactions, and by exploring these capabilities, you are likely to achieve your goals. If you encounter any specific difficulties along the way, feel free to share your progress, and our team will be happy to assist you in overcoming them.
Regards,
Viktor
thanks Viktor,
i appreciate if you can provide an example of no coding using the folowing as im still strugling:
- there is a data table for saved products which the user can save products data “Done”
- the user will generate new request for quotation with number and name and that add to the RFQ Data table when the user will click next “Done”
- i made a new data table “RFQ Products” to save the list of products which will be geberated in the next step and declared one “RFQ” data to many "RFQ Products "relationship “Done”.
- the user will chose one or many poroducts from the saved products to be add to that specific RFQ and specific user and then click submit which will save these products list under the generated RFQ and published
- the user can generate many RFQ with different lists of products which all to be saved under each user
- the application will include many users - many RFQ per each user, many products per each user and per each RFQ.
thanks and appreciate if you can lead me to accompish this task
sherif
Hi @Sherif_elmokadem ,
I do not completely understand your last message. What does RFQ mean?
Basing on your original message you need several tables to implement this:
- Product - table for products
- CustomerSavedProduct - table for customer lists. User will have 1:N relation with this table. Also this table will have relation 1:N with “Product” table.
In case if your “saved products” represent kind of order in your app (it looks like there are some indications of that in your last message) then I would suggest you to reconsider names and introduce additional table for each order entry to be able to save quantity
Regards, Andriy