Approve staff holiday requests via an admin app

Ask for Help
1

Hi, Friends.
I need some assistance regarding employees leave application like any staff will apply for leave then as supervisor/boss someone will approve leave; that staff will get a response like email or message.
Is it possibe in Glideapps???

Thanks in advance.

2

Anything is possible. You just have to start building and learning as your go.

3

I need tips regarding mentioned issue.

4

Start looking at various templates. Take the one that matches your needs the closest. Learn about what is achievable using google spreadsheets scripts and APIs. The mix of glide features and spreadsheet magic will get the job done.

5

@Md_Jakir_Hossain - So there are a lot of steps to this! You might need a Glide Expert to help you https://www.glideapps.com/experts. I will do a tutorial on this in future, but for now - here are some basic thoughts:

From what I can imagine, this may need two apps. 1 for the users (people requesting) and one for the admin (people approving). These will both read from the same sheet.

Stage 1 - users app

  • Use per user data on the users app so that people only see the dates they have requested
  • allow them to add items with start and end dates and a special value to link their email with their requests.

Stage 2 - users app

  • have a column in the sheet for requests which is a status column (i.e. whether it is approved or not). Leave this empty.
  • create a new IFTHENELSE column which says the word ‘Pending’ if the status column is empty ELSE show the text in the status column. Call this column ‘display status’
  • show this new column in a non-editable basic text component

Stage 3 - admin app

  • in the admin app don’t use per user data and show the admin all requests
  • Allow the admin to enter data in the status column for each request via a choice component
  • Give the choice component two choices ‘Approved’ or ‘Denied’
  • Now when the admin chooses approved or denied the users app will show that status rather than ‘pending’.

Stage 4 - filtering

  • You can now (if you want) filter out requests based on status
  • In the admin app - you could create 2/3 views of your sheet with each status (pending, approved & denied)
  • In the users app you could show each user the same - but for only their requests.

Glide Community - please unpick this as I may have missed things out! :pray:t4:

6

@Md_Jakir_Hossain I just want to add that your question is very broad. If you have a working example of what you have made so far, and have questions on a specific problem you are having, then you might get more help from the community. Nobody else but you can envision how you want your app to look and function.

@JackVaughan I would only add that it is possible to get admin and user functionality in the same app, but it’s very use case specific. Usually I like to add either an admin tab in the menu, or add an admin button or list in another tab. Depending on the situation, you can use a combination of per user data, visibility or relations to control if a user can see an admin section of the app.

2 Likes
7

Hi Jake, I have seen your videos and really helped me a lot build my app. However, I have tried the steps and it didn’t really work out for me .

problem # 1. Do I keep all the columns user - specific in the users App ? Or just the start and end date?

Problem # 2: How do I showcase the leave applied from the user app onto the Client App ?

A little help would be a lot for me

8

A lot of things have changed since Jan 20. I would even do it in a single app.

You don’t need to keep them user-specific. Since that data should be available for the admins as well, that’s a hard no. You only use user-specific columns when you need different users to write to a column on the same row.

As I said above, you can do this in one app and have different tabs for different user types. Let’s say one tab for Users to add their leave requests, and filter it so users can only see their request. One other tab for Admins to see requests and approve them, this one you don’t need to have filter (if admins should see all requests).

3 Likes
9

Wow! Yea - blast from the past. Listen to @ThinhDinh. He’s the best.

2 Likes