M:1 relationship - Assign & Update value for a new item

Get Help
1

Hello all

I’m beginner in Adalo.

I want to create e-commerce type app similar to ‘Order’ Default Adalo Template.

In my case, I want to have a ‘Status’ Collection, which indicates status of the order - Started, Confirmed & Paid, Delivered. So 3 items.

My ‘Order’ collection has m:1 relationship with Status collection. Each status can have many orders, one order belongs to one status.

I’m not able to assign default values to ‘Order’ while creating or updating. I am able to assign them via form entry by user. But I need default value to be ‘Started’ when order is created, when customer pays to be ‘Confirmed & Paid’, etc. automatically without user input.

In ‘Order’ template app, status is updated as text. I do not believe this is right way, because on Admin side app, that status should be filter able, etc. And admin should be able to add more status types in future.

Any help appreciated please.

2

See: How to have a Form Automatically Set a Status (or any other related record) - Adalo Resources
You can also search for Default Value in the forum search :wink:

3

Before all, check if Stripe is available in your country…for eCommerce there is no other options as of now.

  • 1 you need to set “Order Status Field” Not visible if user is not an Admin.
  • 2 Visible if user IS an admin, that way user can not change it.
    Probably want to create 2 Admins
  • SysAdmin : Can create new statuses and know what he is doing :slight_smile:
  • SalesAdmin : Can only change status of the order without breaking your App. :grin:
    That way, only SysAdmin can mess with the system… which we hope wont happen
4

Thank you @karimoo and @bibipac

1 Like
5

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.