Hi Team,
Please let me know how can I store days and their opening and closing hours in database table in outsystem.
Hi ujwala,
Can you elaborate more your question?
If you want to Store only days and opening / closing hours in the database, you can create a new Entity with the Attributes (Day, OpeningHour, ClosingHour) and create a screen to insert this values in your database.
If you want to save values only from Monday to Sunday, create for example a static entity (DaysOfWeek) with the days of the week, after that create a new Entity with the Attributes (DaysOfWeekId (Identifier of Static Entity), OpeningHour (Time), ClosingHour (Time)).
Then on your screen you can make logic to save in your database each Day of week schedule as you wish.
Best Regards,
Pedro C.
Hi Pedro,
I have created entity with dayId ,opening hour,closing hour.
But if there are multiple days selection and opening hour closing hour for each day to be inserted in DB table,Then I am not getting how to store those.
Ex. on Grid
Day Monday Tue wed Thursday Friday Saturday Sunday
Openhr-closhr Openhr-closhr Openhr-closhr
And in form:
Day Open Hour Close Hour
Chekbox
Monday textinput TextInput
Tuesday textinput textinput
Similarly all days
Save
Please share if any sample oml.
Thanks
Please find sample oml tried ,
But need in below format.
Hello Ujwwala,
Please find attached the updated OML. Try this and let me know, if you need any other help.
Thanks & Kind Regards,
Sachin