OutSystems - Me Building a Bookings app with Reactive 1/2

I made a Reactive Web Application based on the Traditional Web Application available at OutSystems site. I wanted to make it in one session, but it was longer than I expected, so I divided it into three sessions. I'm planning to make it in three sessions.
OutSystems page where the Traditional Web Application is available.
The explanation in the video is based on the Lesson Materials on the following page
www.outsystems...
Subscribe
/ @masanorich5127

[@laarx007]

Thank you so much for this video, it has helped me a lot! Very clear instructions, even though I do not speak your language. Much appreciated!

[@rizwanali7890]

Thank you so much for providing this video we learn many things from this project you have done a great job Thanks again..

[@user-ex6nb7xx9s]

とても勉強になりました。ありがとうございました。outsysytemsのサイトのlearn>couresesで自習していましたが日本語字幕を追いかけながら画面も確認しながらで悪戦苦闘していました。感謝です。

[@peach_d74]

thanks for the awesome video you posted, the video totally helped me get my task done.. I'm really, really thankful!

[@rizwanali7890]

Please make more video on some more project we learn many things from your video content 🙏

[@gabrielrocha2873]

Thank you so much! although some features are different from the most current version, I managed to use your tutorial to base myself and it was great

[@harinir1697]

Hello sir, I am not getting the booked details under the bookings when running in browser but I booked a room it was booking but not displaying in that page I don't know why can you please tell me.Where I did a mistake.

[@masanorich5127]

The following can be considered for the detail screen 1. There is an error in the Aggregate filter 2. Input Parameter is missing 3. Forgot CreateOrUpdate in Save process

[@harinir1697]

@@masanorich5127 I checked sir but also I am not getting in browser.But in aggregate I am able to see the booked details sir.Now what I have to do sir?

[@masanorich5127]

@@harinir1697 If the reserved data is displayed on the list screen but not on the detail screen when accessed from a browser, the BookingId passed to the detail screen may not be the expected value. You may want to check the Input Parameter (BookingId) passed from the BookingList screen to the BookingDetail screen, or the Aggregate of the BookingDetail screen.

[@harinir1697]

@@masanorich5127 yes sir, actually in your video around 1 hour 5 mintues you are running in browser for the first time sir,in that time you clicked on new booking and gave the details after that you can able to see the details of the booked one sir.But for me it was booking but not displaying in bookings screen of the browser. But in my aggregates I saw my booked details sir in bookings core. So from aggregate to booking detail screen I need to see the input parameter sir.

[@bayuargana2290]

I am stuck at minute 8:01 for adding the Bootstrap file to the room. Where can I find that file?

[@masanorich5127]

Try downloading it from here www.outsystems.com/forums/discussion/35153/need-excel-data-sheet-room-booking-guest/#Post124724

[@valdemiro8465]

Muito obrigado por partilhar conhecimento.

[@GloryHoleBased]

hello there, I am stuck at "Get available room". The result it shows me is always room 101, and when i try to book something it always books for room 301. I have done everything exactly the same as you so what do you think could be the cause here?

[@masanorich5127]

-101 Check Input Parameter in SQLTool, the value entered in Form must be passed. -301 Check the value passed to Booking.RoomId when saving.

[@skypewater6502]

Hello Sir, at 1:26:12 you add RoomID's to the table in the homepage. When adding in the room column to the table it does not show up. I already have checked if rooms are public in the BookingCore, but yet it does show up. What could be done about this?

[@masanorich5127]

Hi, thanks for the question. Please check the following: ・Is the data type of RoomId set to Room Identifier? ・Is the reference to the Core module up-to-date?

[@geoffreyortiz9652]

Hello Sir, everytime I book a room it records the booking but the room number is always at zero. What could be done about this?

[@masanorich5127]

I think the reason is that the Room.Id obtained from SQL is not assigned to Booking.RoomId.

[@minebay8683]

Hello Sir, at 1:09:54 you assess the fact that you can check out John Doe, if you are not able to check him out. I did walk through the steps once again but yet does the button show up. What if statement or expression is responsible for this?

[@masanorich5127]

* Is the reservation status being evaluated correctly? * Is the IF True/False placement correct? Please check the following points.

[@skypewater6502]

Sir, at 42:52 you are filling in those new Amenity records. Down attribute values you can see Id (Auto Number). Down at my OutSystems it keeps forcing to fill in an ID as it gives error: Value must be set, how do i fix this?

[@masanorich5127]

Hi, Make sure the Is AutoNumber property of the Id Attribute is Yes.

[@skypewater6502]

Thanks for such quick reply sir!

[@dharanyaj4163]

Sir... I drag the rooms screen to paste the menu tap but don't paste.. what mistake I make

[@masanorich5127]

The drop destination must be a Menu block. Check to see if the Menu block is present at the drop location; it is easier to check if it is in the Widget Tree.

[@vinodkumarreddy7605]

When I clicked get available room " Error executing query" coming how can I resolve it

[@masanorich5127]

There seems to be an error in the SQL you executed. Please compare the SQL with the text to see if it is reflected in Service Studio.

[@tinybui3801]

hi Sir I have followed this up to 1:06:00 . when i publish the page at this point and test functions of the " Get availablr Rooms " button don't anything , how to fix it . Thanks

[@masanorich5127]

If this problem has not been resolved, check the following A common mistake is incorrectly setting parameters to the SQL node. Are the values of each input field being passed to the SQL? It would be a good idea to check this point.

[@tinybui3801]

@@masanorich5127 i have checked the SQL input variable is still being received but still nothing happens when i click button " Get Available Rooms"

[@masanorich5127]

@@tinybui3801 Also check the following Has SQL been able to acquire available rooms? Can you assign the retrieved vacant room information to the Booking record to be saved? Are the values set to the properties for displaying the Book Room button when the vacant room information is retrieved?

[@EmmanuelAdefila]

Hello, thanks for this great video. I managed to set up same App but could not add a new booking when I clicked on "bookings --> New booking" fill the form and clicked on the submit button the new booking will be added BUT deleting the previous addition. . Is there something I'm missing even though I have rechecked the logic and found none?

[@masanorich5127]

One common mistake is that the property value "IsAutoNumber" of the Id Attribute of the Booking Entity is set to "No". Is the value set to "Yes"?

[@EmmanuelAdefila]

@@masanorich5127 Many thanks for your response. The Id attribute of the booking entity is set to "Yes" and the database wouldn't allow me to change it to "No". What do you think I can do to resolve this please?

[@masanorich5127]

@@EmmanuelAdefila In the Save action on the BookingDetail screen, make sure that CreateOrUpdateBooking is called. If it is called correctly, a new booking record will be added to the Booking Entity created in the BookingCore module. The record will be added if the Id Attribute of the Booking Entity is greater than or equal to 1. If you look at the action that is being called and the record that is being added to the Booking Entity, you may find bugs.

[@GeraldySeptianAnarchy]

Hello sir, I have followed your method but Why is my data not showing in Check In Today & Check Out today?

[@masanorich5127]

Hi, do you have any of the following... If it's a check-in date, have you created data for Booked? If it is a check-out date, have you created Chekced-In data? Have you created the Aggregate filter correctly? Is the widget placed in the Homepage correct?

[@GeraldySeptianAnarchy]

@@masanorich5127 Yes data is showed in Booking, but on Homepage Check In Today & Check Out Today is not showing sir

[@masanorich5127]

@@GeraldySeptianAnarchy Check the Aggregate preview to see if it shows the data you expect

[@GeraldySeptianAnarchy]

@@masanorich5127 thanks sir

[@ramonsoares2458]

te amo japa da outsystems

[@ukdc-acdctribute1142]

Hello, I have followed this up to the first 34 minutes. When I publish the page at this point and test the functions of the "Get available Rooms" and "book Room" buttons they do not work. "get available Rooms" button doesn't do anything, "book Room" give me an error. Is this normal at this stage? should I ignore this for now and hope that it gets fixed later in your video? I have watched the first 34 minutes 3 times now and have done everything exactly the same. I am building on Traditional web app if this makes any difference. Thank you.

[@masanorich5127]

Hello, At 34 minutes, BookRoom is a success. I just forgot to create the New Booking link on the Bookings screen, and if you've followed the steps so far, you can book as expected. If you follow the steps so far, you can book as expected.

[@ukdc-acdctribute1142]

@@masanorich5127 ok thank you. Ill go back through it and see if I can see anything i have done differently. Also my version of Outsystems is different to yours, im using v11 and dev space, not personal.

[@ukdc-acdctribute1142]

Hi. I have just gone through this a 4th time (Up to the first 34 Mins). Piece by piece, doing everything the same as you have and the action to "Get Available rooms" definitely isn't working. The Module is Valid with no Errors or warnings but the action to "Get available rooms" doesn't do anything, it just clears the booking form and doesn't update the "room XX at $xx Per nigh row. I have not done anything different to the steps in your video. Unfortunately, you do not test your module during the video to see if each step works as it should. The only thing different is that I am building in traditional web app so i build tables in the screen preparation. i have built the Server action and SQL in the same way you have done. Do i need to do this differently in Traditional Web App? Thank you for your help.

[@masanorich5127]

Hi. In the case of Traditional Web, the procedure is different from ReactiveWeb. The following are possible reasons why the Get Available Room button does not work as expected. * The assignment to BookingForm.record is not appropriate. Set BookingForm as Variable and SQL.List as Value. * The method of the Get Available Room button is not Submit, if it is a Submit method, the Get Available Room Screen Action is only two statements (SQL , Assign). Or, if the method is Ajax Submit, there is no Ajax Refresh.

[@ukdc-acdctribute1142]

@@masanorich5127 Thank you. I had to change a whole bunch of things, i honestly don't know what i did and it has took me all day but by complete luck i have got it running and successfully displaying the bookings. Thank you for taking the time to help me.

[@pritampradhan4483]

@@ukdc-acdctribute1142 can you help me with the link of traditional booking app development video ? It will be a immense help .Thanks in advance

[@pritampradhan4483]

@@masanorich5127 can you help me with the link of traditional booking app development video ? It will be a immense help .Thanks in advance

[@masanorich5127]

@@pritampradhan4483 traditional booking link? => www.outsystems.com/training/lesson/849/bookings-assignment

[@dedibagus610]

28:28 my project didn't get the entities, can u help me?

[@masanorich5127]

There may be omissions in the addition of records to the Static Static Entity on the Core module side.Please check if the following four records have been added. CheckedIn, CheckedOut, Booked, Canceled

[@dedibagus610]

@@masanorich5127 oooohhhh, thank you so much

[@dedibagus610]

@@masanorich5127 when i click get avaliable room, my booking detail does not appear price and room number, why?

[@dedibagus610]

@@masanorich5127 i have another problem, when i click get available rooom, detail booking does not appear price and room, do u know why?

[@duartedsmoreira]

Can you do it until the end and upload it before Wednesday? Thanks

[@masanorich5127]

Next video has been published. Please check it out.

[@duartedsmoreira]

@@masanorich5127 love u

[@pritampradhan4483]

@@masanorich5127 Can you please provide a video or process of solution of traditional booking app please.It wil be immense help

[@masanorich5127]

@@pritampradhan4483 OK, I'll make a traditional version, you'll just have to wait.

[@pritampradhan4483]

@@masanorich5127 Thanks in advance.It will be really helpful if you do it quickly. I shall be grateful towards you.

[@django27gaming81]

can you please share oml file of this booking site.

[@masanorich5127]

Unfortunately, I did not save the OML at this time. It was created in my personal environment and disappeared due to suspend.

[@masanorich5127]

If you are getting an error, I may be able to advise you.