Cut off number of leave work

AppSheet AppSheet Q&A
1

cut off number of leave work

The app I want is When filling out leave information and select the number of leave with leave type let it automatically deduct

such as
I have a vacation of 10 days.

  1. Code 10101 Mr. Mai Date of leave 12/12/2021 End date 13/12/2021 Number of leave 2 days Type of vacation
    When the key is finished, vacation for 10 days must be deducted for 2 days on leave, leaving 2.

I am entitled to 30 days of sick leave.
2) Code 10101 Mr. Mai Date of leave 13/12/2021 End date 13/12/2021 Number of leave 1 day Type of sick leave
When the key is finished, 30 days of sick leave must be deducted for 1 day of leave, leaving 29 left.

want to subtract Subtract the number of days followed by categorizing the number of sick leave days in this employee code, how many days are left.

2

Hi @fon

You may want to change your post category to “Question”.
What did you try so far ? Can you share screenshot of your table structure ?

1 Like
3

i want to make appla by deducting the amount of leave according to the type of leave

For example, if I’m on vacation, leave, and vacation privileges must be subtracted

4

Thanks.
I don’t read any answer to my questions

Aurelien:

What did you try so far ? Can you share screenshot of your table structure ?

2 Likes
5

This is leave information.
Main table, name, main employee (has a duty to show the code, name-surname of each person to show who’s information of it) But when adding data, add it to the secondary table only)

Secondary table, name of employee leave work (secondary table will refer to the main table)

3X_5_b_5bd5392252a3d891b2301f4e415fd6694498f5a5.jpeg
3X_5_b_5bd5392252a3d891b2301f4e415fd6694498f5a5.jpeg780Ă—423 61.2 KB

This page will show how much leave has been awarded. and how many are left

3X_e_e_ee83723e0832842845f962d637556a566b0b6fb3.png
3X_e_e_ee83723e0832842845f962d637556a566b0b6fb3.png778Ă—445 65.7 KB

But the table of employee leave information There will only be a page to show the number of rights that have been left. and balance

example
I got 10 vacation days.
I take 1 day leave from 12-12-2021. My vacation must be 9 days left.

But since there are many types of leave I want to calculate per status of leave type. If the leave is vacation, then the vacation is deducted, if the leave is sick leave, then the sick leave is deducted.

calculated per type

6

Hi @fon

It’s not exactly clear to me the way you want to perform it, but you will probably need to combine various expressions:

Here is an example of what you may want to produce. This expression will calculate the remaining days, based on 10 days for Sick leave.
You may want to make a summary “per leave type” ?

IFS([vacationType]="Sick",
  10
  -SUM(
    SELECT(EmployeeLeaveTable[TotalLeave],
      AND(
        [EmployeeCode]=[_THISROW].[EmployeeCode],
        [vacationType]=[_THISROW].[vacationType],
        YEAR(TODAY())=YEAR([LeaveStartDate])
      )
    )
  ),
[vacationType]="Holidays",
  {similarCalculationForHolidaysVacationType}
)
2 Likes
7

Then take annual vacation Each person will be entitled to annual vacation differently.

How do I define it?

8

In

IFS([vacationType]="Sick",
  10
  -SUM(...

Replace the 10 per [EmployeeCode].[annualVacation] expression

9

but my type column is enum has optional like

  1. Sick leave (with the right to leave 30 days / year)
  2. Business leave (entitled to leave 8 days / year)
  3. Annual vacation leave (The number of days each person will receive is not the same)
  4. Special leave (with the right to leave 3 days / year)

[annualVacation] is not a real columnist. But it’s an option in Enum. …

[annualVacation] Here, we have to switch to " annualVacation" instead?

10

Aurelien:

annualVacation

Happy New Year

I still can’t solve this formula.

11

Hi @fon

Happy new year as well.

I won’t spend more time on this thread, as you don’t provide any information on what you tried so far.

As a reminder, the useful elements for your need are:

  • IFS() expression (alternatively: SWITCH())
  • SELECT() expression
  • dereference expression

Some additional tips though:

  • if some vacation type is specific to people or job: you can use dereference expression
  • if it’s standard: you can use a constant value such as it is in my expression exemple with “10”

For reference:

2 Likes