Hi Ahmad Zaenal Awaludin,

Can you show the screenshot of the action SaveOnClick? You have to set a CreateOrUpdate Entity action to store the selected dropdown value. The selected dropdown value stored in the Local Variable would  Room.Id as you have set Value of the dropdown as Room.Id.

Regards,

Manthan Shah.

Manthan Shah wrote:

Hi Manthan below screenshot action save on click

i have condition check room booking or not by RoomId local variable, and if room not booking iwant to save Roomid local variable to database

Ahmad Zaenal Awaludin wrote:

Use the aggregate of Room Entity and assign a filter to it like Room.Id = RoomId(Local Variable) . Hope this helps.

Manthan Shah wrote:

oke this no problem, problem is RoomId(Local Variable) not save to database. and i confuse

Hi Ahmad,

You don't need to use a local variable.
You should use your RoomId foreign key from the booking entity.

If you really need to use a local variable, you should set record's RoomId foreign key from your local variable before you save.

With best regards,
F.Karatay

Ferhat Karatay wrote:

Hi Ferhat

any tutorial for set record's RoomId foreign key from local variable 

Ahmad Zaenal Awaludin wrote:

Hi Ahmad,

You can download an example here; https://we.tl/t-nWp2EnnPXn
However, I also strongly suggest you watch learn materials. They are very useful to learn.

With best regards,
F.Karatay

Hi Ahmad,

1. Create an action in your logic tab for instance; CheckRoomAvailable
2. Set input parameters RoomId, StartDate, EndDate and Output parameter IsAvailable
3. In your action check from the database your room available or not
4. Set output parameter
5. Call that action in your save action and check result
   
   For instance;
   For the best performance; you can put all your logic in a single action and you can call that action in save button. Also, I strongly suggest you study learning materials.
   
   With best regards,
   F.Karatay

Hi,

You can find in the attachment.


With best regards,
F.Karatay