Resource Booking e.g. Booking of Conference Room – MyDataOrganizer Online Database Platform

Question from Sam B. : Resource Booking ( Conference Room, Equipment , Appointment etc. )

Basic Requirements of the application :


  • Applications like Conference Room Booking, Appointment Setting, Project Resource Scheduling
    need to make sure that there is no conflict when it is done.
  • When Conference Room is already booked for certain time period
    then it should not be allowed to book the conference room during booked time period.
  • Booking Requests Conflicts should be shown.
  • Only requests which do not have conflict will be shown with BookIt link to confirm booking.

Security Needs :
  • Only certain people would be allowed to initiate booking of conference room.
  • Only certain people would be allowed to set status of conference room to Booked from Initial.

The latest version of this document is maintained at ResourceBooking Reserve Conference_Room MyDataOrganizer OnlineDatabase Platform

Allow viewing of USA Address in custom Postal Format – MyDataOrganizer Online Database Platform

Question From Shirley :

Sometimes custom viewable format for data is needed.

e.g. USA Address in tabular/grid/spreadsheet format is as following.



USA Postal Address uses the format by having street data in the first line followed by city, state and zip-code in the second line.



Following Configuration will allow USA Address in Postal Format.



Both Spreadsheet/Tabular and Postal Format are also allowed to be viewable.

The latest version of this document is maintained at USAAddress_Tabular_and_Postal_Format_MyDataOrganizer_OnlineDatabasePlatform

Personalize Query Data Filters with Custom Condition – Online Data Organizer using Online Database Platform – Question by Sam H.

Paid Time Off Requests are managed.

Goal is to personalize result for managers to find out if there are any requests pending for their approval.

It can be done by configuring Custom Condition.

All the requests without any filter are shown below.



Each table/spreadsheet has menu option of Custom-Condition.



When Custom-Condition Menu is clicked it results into all Custom Conditions for the table.



When Get link is clicked it shows all the data corresponding to custom condition.

In our case it will show all the requests pending for approval for current user.



If find link is clicked (for the custom condition) then it will show form options for further filtering of data.

The latest version of this document is maintained at CustomCondition_QueryDataFilters_OnlineDataOrganizer_MyDataOrganizer_OnlineDatabasePlatform

Personalize Query Data Filters Online Data Organizer using Online Database Platform – Question by Sam H.

Paid Time Off Requests are managed.



For each table ( spreadsheet ) there are three options for Data Query Filters.

  • Save Public Query
  • Save Personal Query
  • Get Saved Query
  • Save Public Query : If the user has permission then user will be able to save query for all the users ( i.e. public )
  • Save Personal Query : If the user has permission then user will be able to save query for personal use. Other users will not have access to this personal query.
  • Get Saved Query : It will get saved query ( personal and public ) for the table ( spreadsheet involved ).



Get Saved Query returns the following list for Paid Time Off Requests.



User can either execute query or get the query which provides option to have additional filters.



List of Approved Paid Time Off Requests.



List of Submitted Paid Time Off Requests.



List of Denied Paid Time Off Requests.

The latest version of this document is maintained at QueryDataFilters_OnlineDataOrganizer_MyDataOrganizer_OnlineDatabasePlatform

Students-Classes Online Data Organizer using Online Database Platform – Question by Chandrajeet






  • Organize Students and Classes
  • Do not admit student if class is full as per Class-Size.
  • Do not allow same to student to enroll in the same class more than once.
  • Report Number of Classes Student has enrolled
  • Report Number of Students each class has.

The latest version of this document is maintained at Students_Classes_OnlineDataOrganizer_MyDataOrganizer_OnlineDatabasePlatform