How to make a schedule for booking appointments to visit schools by supervisors. So that no more than one supervisor can visit the specified school in one day
Solved! Go to Solution.
You should have at least the following table:
- ูAppointments table
- Schools table
- Supervisors table
- Agenda table
They will be "combined" in the Appointments table that would contains reference columns to each of the three other tables.
Once you have this established, it will be easy to write an expression to exclude already-booked schools in a particular day.
Please read this: References Between Tables | AppSheet Help Center
ุฃููุงู ุจู
ุงูุณูุงู ุนูููู ,
I don't see a single reference in any of your tables. It is important that you study the first link I posted carefully: References Between Tables; not just for this simple task, but because as you progress with your app, you'll keep running into obstacles and possibly unsolvable problems without establishing correct references between your tables.
Anyway, based on your current table, it seems that your room booking form is based on the Schedule table. So in this table you should add at least a Ref column to the Schools table.
When a user is inside this form, and chooses a certain date, then the "School" column should show only the schools not already booked for a visit during this day. For this you should put the expression below in the Valid if field in the "School" column:
School Data[NUM] - SELECT(Schedule[School], [date-m] = [_ThisRow].[date-m])
If the user instead selects the school first, then the Date column should not allow dates booked already for the selected school. For this you should use this expression in the Valid if field of the "date-m" column:
ISBLANK(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
)
And add an error msg here something like: "Date already booked for this school. Please choose another date or another school."
In both expressions above we have used List Subtraction.
_______
Is your "date-h" column for ูุฌุฑู dates? If so, what method you are using for the date conversion please? ุดูุฑุงู ุฌุฒููุงู!
Thanks my friend, this is kind of you.
Actually I was just curious about the method you might be using. I know of three methods:
ุนูููู ุงูุณูุงู ูุฑุญู ุฉ ุงููู ูุจุฑูุงุชู
ln this case we must have a log of schools visited twice during a given week. One way to do this is to create a slice on the Schedule table. Let's name it twiceWeeklyVisits. The slice's Row filter condition would be:
COUNT(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
))
) >= 2
The twiceWeeklyVisits slice will contain all Schedule records, visiting the same school during the same week, at least twice. From now on, the form will not allow more than two visits, but the slice has to accommodate for earlier records, that's why we used ">= 2" instead of "= 2".
Now back to our earlier expressions. The Valid if field of the School column should have the following formula:
School Data[NUM]
- SELECT(Schedule[School], [date-m] = [_ThisRow].[date-m])
- SELECT(twiceWeeklyVisits[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
)
The Valid if field of the date-m column, should in turn have this formula:
ISBLANK(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
))
)
You should have an Appointments table referencing both a Schools table and an Agenda table containing booked dates.
In your Appointment Form, after choosing a date, your form should display a list of schools to the user, excluding the schools that have appointments for the chosen day.
Very nice
Could you explain to me more?
Do I create two schedules, one for appointments and one for schools
How are they combined?
Are there functions?
With thanks
You should have at least the following table:
- ูAppointments table
- Schools table
- Supervisors table
- Agenda table
They will be "combined" in the Appointments table that would contains reference columns to each of the three other tables.
Once you have this established, it will be easy to write an expression to exclude already-booked schools in a particular day.
Please read this: References Between Tables | AppSheet Help Center
ุฃููุงู ุจู
Wonderful
Already i have created the four tables.
Can you help me write an expression to exclude schools already booked on a particular day.
best wishes
Please show the column of your tables.
The expression would be based on a SELECT() statement operating on the Agenda table, and would be used inside the Valid if field of your Ref column to the Schools table.
Now that you have read the first guide, please also read the following guides:
SELECT() | AppSheet Help Center
I read the guide
I wrote this formula
But it didn't work
SELECT(School data [schoolname], ([schoolname] = [shcoolname]), TRUE)
Please post screenshots showing the columns of your tables from the app editor. Thank you.
These are the pictures of the tables
Thank you.
ุงูุณูุงู ุนูููู ,
I don't see a single reference in any of your tables. It is important that you study the first link I posted carefully: References Between Tables; not just for this simple task, but because as you progress with your app, you'll keep running into obstacles and possibly unsolvable problems without establishing correct references between your tables.
Anyway, based on your current table, it seems that your room booking form is based on the Schedule table. So in this table you should add at least a Ref column to the Schools table.
When a user is inside this form, and chooses a certain date, then the "School" column should show only the schools not already booked for a visit during this day. For this you should put the expression below in the Valid if field in the "School" column:
School Data[NUM] - SELECT(Schedule[School], [date-m] = [_ThisRow].[date-m])
If the user instead selects the school first, then the Date column should not allow dates booked already for the selected school. For this you should use this expression in the Valid if field of the "date-m" column:
ISBLANK(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
)
And add an error msg here something like: "Date already booked for this school. Please choose another date or another school."
In both expressions above we have used List Subtraction.
_______
Is your "date-h" column for ูุฌุฑู dates? If so, what method you are using for the date conversion please? ุดูุฑุงู ุฌุฒููุงู!
You are so amazing and so beautiful ๐๐
All expressions work very well
Thank you very much ๐
For the Hijri date
I'm converting the date and entering it manually as text
I will look for a way to convert it and maybe ask in the APPSHEET community
If I find a way, I will send it to you.
Thanks my friend, this is kind of you.
Actually I was just curious about the method you might be using. I know of three methods:
ู ุง ุดุงุก ุงููู
you are creative
Thanks, my friend
I learned a lot from you
I hope to cooperate in the future
ุจุฅุฐู ุงูููุ ูููู ูู ุงูุดุฑู
ุงูุณูุงู ุนูููู
hello joseph
If you want to write an expression, to make a maximum visit to the school twice a week from all supervisors.
What can I add to the previous expression?
ุนูููู ุงูุณูุงู ูุฑุญู ุฉ ุงููู ูุจุฑูุงุชู
ln this case we must have a log of schools visited twice during a given week. One way to do this is to create a slice on the Schedule table. Let's name it twiceWeeklyVisits. The slice's Row filter condition would be:
COUNT(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
))
) >= 2
The twiceWeeklyVisits slice will contain all Schedule records, visiting the same school during the same week, at least twice. From now on, the form will not allow more than two visits, but the slice has to accommodate for earlier records, that's why we used ">= 2" instead of "= 2".
Now back to our earlier expressions. The Valid if field of the School column should have the following formula:
School Data[NUM]
- SELECT(Schedule[School], [date-m] = [_ThisRow].[date-m])
- SELECT(twiceWeeklyVisits[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
)
The Valid if field of the date-m column, should in turn have this formula:
ISBLANK(
FILTER(Schedule, AND(
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
))
)
You are really creative
Expressions are already working.
Just
If I wish to add a phrase
SCHEDULE[date-m]
The date is automatically inserted
to express
ISBLANK(
FILTER(Schedule, AND)
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits,
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
)
)
So what do I use?
I'm sorry, I don't understand. Would you please explain further? Thanks.
I apologize that I cannot pass the information on to you
I mean:
That the [date-m] field I already put the statement in :
SCHEDULE [date-m]
The date will be added automatically
If I add to it the expression you sent me, which is:
ISBLANK(
FILTER(Schedule, AND)
[School] = [_ThisRow].[School],
[date-m] = [_ThisRow].[date-m]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits,
ISOWEEKNUM([date-m]) = ISOWEEKNUM([_ThisRow].[date-m])
)
)
How do I combine the two expressions?
I hope I have made it more clear
Sorry again I can't make sense of this, how would Schedule[date-m] automatically add the dates? this would rather restrict you to dates already registered and prevent you from adding new dates.
Let's forget about the expressions. Please just explain in plain language what do you want to do. You want the date to be automatically filled, based on what criteria?
ู ู ูู ุชูุชุจ ุจุงูุนุฑุจู ูู ุชุญุจ..
ุจุงููุนู ุฃุฑุบุจ ุงููุชุงุจุฉ ุจุงููุบุฉ ุงูุนุฑุจูุฉ ุจุฏู ุงุณุชุฎุฏุงู ุงูุชุฑุฌู ุฉ ๐
ุญูู (ุงูุชุงุฑูุฎ ุงูู ููุงุฏู) ูุฏู ู ุฑุชุจุท ุจุงูุฌุฏูู ุงูุฒู ูู ููุฃุฎุฐ ุงูุจูุงูุงุช ู ู ุงูุฌุฏูู (SCHEDULE)
ููุชูุถูุญ ุฃูุซุฑ ูู ุงูุตูุฑ ุงูู ุฑููุฉ
ุฃุฑุบุจ ูู ุฅุถุงูุฉ ุงูุชุนุจูุฑ ุงูุฐู ุฃุฑุณูุชู ุงูุช ูุงูุฐู ูุจุฏุฃ ุจู (ISBLANK)
ู ุน ุงูุตูุบุฉ ุงูุฃููู
ุฌุฑุจุช AND ููู ุชุนู ู
ุงุนุฐุฑููู ุนูู ุงูุฃุฒุนุงุฌ..
ุงูุณูุงู ุนูููู ุ ูุง ููุฌุฏ ุฅุฒุนุงุฌ ุฃุจุฏุงูุ ุงููุฏู ู ู ูุฐุง ุงูู ูุชุฏู ูู ุชูุฏูู ุงูู ุณุงุนุฏุฉ ูุจุนุถูุง ุงูุจุนุถ..
ุฃููุงู: ู
ุง ูู ุงููุฑู ุจูู ุงูุฌุฏููููุ
Agenda ู Schedule?
ุฃุฑู ุฃููู
ุง ูุญุชููุงู ุนูู ููุณ ุฃุณู
ุงุก ุงูุฃุนู
ุฏุฉ ุจุงูุถุจุท ู
ุน ุชุฑุฌู
ุฉ ุงูุฃุณู
ุงุก. ุฅุฐุง ูุงู ุงููุฏู ูู ุฅุธูุงุฑ ุงูุฃุณู
ุงุก ุงูู
ุชุฑุฌู
ุฉ ูู ุงูุชุทุจููุ ููู
ููู ุจุฏูุงู ู
ู ูุฐุง ุงุณุชุฎุฏุงู
ุญูู
Display Name
ูุฅุฐุง ูุงู ุงููุฏู ุบูุฑ ุฐููุ ูุฑุฌุงุกู ุชูุถูุญ ุงูุณุจุจ ูุฑุงุก ูุฌูุฏ ุงูุฌุฏูููู ุณููุง
ุซุงููุงู: ุญูู
Valid if
ูุธููุชู ูู ุงุณุชุจุนุงุฏ ุงูููู
ุงูุชู ูุง ุชุญูู ุงูุดุฑูุท ุงูู
ุฏุฑุฌุฉ ูู ุงูุชุนุจูุฑ ุงูู
ุฏุฑุฌ ุฏุงุฎู ุงูุญููุ ูููู ูุง ูู
ูู ุงุณุชุฎุฏุงู
ู ูุฃุฌู ุงูู
ูุก ุงูุชููุงุฆู ูููู
ุฉ ุงูุนู
ูุฏ
ุจุดูู ุนุงู ุ ุจุนูุฏุงู ุนู ุงูุชุทุจููุ ุจุญุณุจ ู ุง ููู ุชุ ูุฃูุช ุชุฑูุฏ ู ูุก ุงูุชุงุฑูุฎ ุชููุงุฆูุงู ุญูู ุญุฌุฒ ู ูุนุฏ ุฌุฏูุฏ ูุฒูุงุฑุฉ ุงูู ุฏุฑุณุฉ.. ุงูุณุคุงู ูู: ู ุง ูู ุงููุงุนุฏุฉ ุงูุชู ุชุฑูุฏ ู ูุก ุงูุชุงุฑูุฎ ุนูู ุฃุณุงุณูุงุ ู ุง ุงูุฐู ููุช ูุชูุนูู ุจุงุณุชุฎุฏุงู ุงููุฑูุฉ ูุงูููู ุจุฏูู ูุฌูุฏ ุงูุชุทุจููุ ุดูุฑุงู
ุดูุฑุง ุฌุฒููุง ูู
- ุงูุฌุฏูู (1)
Schedule
ูุญุชูู ุนูู ุงูุฃุณุงุจูุน ูุงูุฃูุงู
ู ุงูุชูุงุฑูุฎ ุงูุซุงุจุชุฉ ููุนุงู
ุงูุฏุฑุงุณู
- ุงูุฌุฏูู (2)
Agenda
ูู ุงูุฌุฏูู ุงูุฒู
ูู ููู
ุดุฑู ุญูุซ ุณูููู
ุจุฅุฏุฎุงู ุงูุฒูุงุฑุงุช ููู.
ุงููุงุนุฏุฉ ูู : ุฌูุจ ุงูุฃุณุจูุน ูุงูููู ูุงูุชุงุฑูุฎ ุงููุฌุฑู ูุงูู ููุงุฏู ู ู ุงูุฌุฏูู (1) ูุฅุถุงูุชูุง ููุฌุฏูู (2)
----
ู ูุงุญุธุฉ : ุงูุทุฑููุฉ ุงูุชู ุฃุฑุณูุชูุง ูู ูู ุงูุตูุฑุฉ ุงูุฃููู ุชุนู ู ู ุนู ุจุดูู ุฌูุฏุ ููู ุงูู ุดููุฉ ุนูุฏ ุฅุถุงูุฉ ุชุนุจูุฑ ุขุฎุฑ ุนูููุง ูุง ูุนู ู ุงูุชุนุจูุฑ.
ู ู ู ู ู .. ุดูุฑุงู
ุทูุจ ู
ุจุฏุฆูุงู ููุฃุณู ูู ู
ุง ุณุจู ูู ูุนู
ู ุจุตูุฑุฉ ุตุญูุญุฉ ูุฃู ุงูุชุนุจูุฑุงุช ูุฌุจ ูุถุนูุง ูู ููุณ ุงูุฌุฏูู ุงูุฐู ูุชู
ู
ู ุฎูุงูู ุชุณุฌูู ุงูุฒูุงุฑุงุช ููู ุญุงูุชูุง ูุฐุง ุงูุฌุฏูู ูู:
Agenda
ูููุณ:
Schedule
ุงูุชุนุจูุฑุงุช ุณูุชู ูุจูููุง ู ู ุฎูุงู ุงูุชุทุจูู ููู ุชุธูุฑ ุฃูุฉ ุฃุฎุทุงุก ุญูู ุฅุฏุฎุงู ุงูุชุนุจูุฑุงุชุ ูุฃููุง ูุบููุงู ุตุญูุญุฉ.. ููููุง ูู ุชุนุทู ุงููุชูุฌุฉ ุงูู ุฑุฌูุฉ.. ุนูู ุณุจูู ุงูู ุซุงูุ ุฅุฐุง ููุง ูุจุญุซ ุนู ุงูุฒูุงุฑุงุช ุงูุณุงุจูุฉ ูู ุนุฑูุฉ ูู ุชู ุช ุฒูุงุฑุฉ ููุณ ุงูู ุฏุฑุณุฉ ูู ููุณ ุงูููู ุฃู ู ุฑุชูู ุฎูุงู ููุณ ุงูุฃุณุจูุนุ ูุงูุชุนุจูุฑ ูููู ุจุงูุจุญุซ ูู ุฌุฏูู ุงูุชูุงุฑูุฎ ุงูุซุงุจุชุฉ ููุนุงู ุงูุฏุฑุงุณู, ูููุณ ุฌุฏูู ุงูุฒูุงุฑุงุชุ ูุจุงูุชุงูู ุญูู ุงุณุชุฎุฏุงู ุงูุชุทุจูู ูู ุชุธูุฑ ูู ุงูุชูุงุฑูุฎ ุงูู ุทููุจุฉ ุจุทุฑููุฉ ุตุญูุญุฉุ ูุฃู ุงูุจุญุซ ูุง ูุชู ูู ุงูู ูุงู ุงูุตุญูุญ..
ูุง ุชูุฌุฏ ู ุดููุฉุ ุณูููู ุจุถุจุท ุงูุชุนุจูุฑุงุช ุงูุณุงุจูุฉ ู ู ุฌุฏูุฏ ู ุน ุชุบููุฑ ุงูุฌุฏูู ุฏุงุฎู ุงูุชุนุจูุฑ..
ุฃููุงู: ุฅุฐุง ููุช ูุฏ ุฃุถูุช ุนู ูุฏุงู ููู ุฏุฑุณุฉ ุฏุงุฎู ุฌุฏูู ุงูุชูุงุฑูุฎ ุงูุซุงุจุชุฉ ุจูุงุกู ุนูู ูุตูุญุชู ุงูุณุงุจูุฉ ููุฌุจ ุนููู ุงูุขู ุฅุฒุงูุชู.. ุฑุจู ุง ูู ุชูุนู ุฐูู ุจู ุฃุถูุช ุงูุนู ูุฏ ุฅูู ุฌุฏูู ุงูุฒูุงุฑุงุชุ ููู ุงูุฅุฌุฑุงุก ุงูุตุญูุญ..
ุซุงููุงู: ูุฌุจ ุฅุฌุฑุงุก ุงูุชุบููุฑุงุช ุงูุชุงููุฉุ ูุณูููู ุฃูุถุงู ุจุฅุถุงูุฉ ุชุนุจูุฑ ุฅุถุงูู ููุณู ุงุญ ููุท ุจุงูุฒูุงุฑุงุช ุฎูุงู ุงูุชูุงุฑูุฎ ุงูุซุงุจุชุฉ ููุนุงู ุงูุฏุฑุงุณูุ ููุง ูู ูู ู ุซูุงู ุฅุฌุฑุงุก ุฒูุงุฑุฉ ูู ุฏุฑุณุฉ ุฎูุงู ุงูุนุทูุงุช ุฃู ููุงูุฉ ุงูุฃุณุจูุน
1. The Slice
ูุฌุจ ุฅูุดุงุคูุง ู ู ุฌุฏูู ุงูุฒูุงุฑุงุช ูููุณ ุฌุฏูู ุงูุชูุงุฑูุฎ ุงูุซุงุจุชุฉ ููุนุงู ุงูุฏุฑุงุณู
Create a slice on the Agenda table. Let's name it twiceWeeklyVisits. The slice's Row filter condition would be:
COUNT(
FILTER(Agenda, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]) = ISOWEEKNUM([_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
))
) >= 2
2. The Agenda Table
The Valid if field of the School column, should have the following formula:
School Data[NUM]
- SELECT(Agenda[School], [ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
- SELECT(twiceWeeklyVisits[School],
ISOWEEKNUM([ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]) = ISOWEEKNUM([_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
)
The Valid if field of ุงูุชุงุฑูุฎ ุงูู ููุงุฏู column, should in turn have this formula:
AND(
IN([_This], Schedule[date-m]),
ISBLANK(
FILTER(Agenda, AND(
[School] = [_ThisRow].[School],
[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]) = ISOWEEKNUM([_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
))
)
)
ุฑุงุฆุน
ุจุงููุนู ุฃูุง ููุช ุฃุบูุฑ ูู ุงูุชุนุจูุฑุงุช ุญุณุจ ู
ุง ุฃุฑูุฏ ููุงูุช ุชุนู
ู ู
ุนู
ููู ู
ุชุทุงุจูุฉ ููู ู
ุง ูุชุจุช ูู ุฑุณุงูุชู ุงูุฃุฎูุฑุฉ
ูู ู
ุง ููุช ุฃุฑูุฏู ูู ูุฐุง ุงูุชุนุจูุฑ ููููู ูุง ูุนู
ู ุฑุจู
ุง ูููู ูุงูุตุงู ููุฏ ูู
ุช ุฃูุง ุจุชุนุฏููู ูุฃุฑุฌู ู
ูู ู
ุฑุงุฌุนุชู
AND(
IN([_This], Schedule[date-m]),
ISBLANK(
FILTER(Agenda, AND(
[School] = [_ThisRow].[School],
[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits, AND(
[School] = [_ThisRow].[School],
ISOWEEKNUM([ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]) = ISOWEEKNUM([_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
)
)
)
)
ุทูุจ ู ุซูู ุง ูููููู ุฅุฐุง ุนุฑู ุงูุณุจุจ ุจุทู ุงูุนุฌุจ ๐ ุดูุฑุงู
ุนุฐุฑุงู ูุฐู ุบูุทุฉ ู ูู ูุณูุช ุฅุถุงูุฉ ูุฐุง ุงูุฌุฒุก ูุฃูุช ูู ุช ุจุฅุถุงูุฉ ุงูู ุทููุจ ูุจุงูุทุฑููุฉ ุงูุตุญูุญุฉ.. ุฃุญุณูุช!! ๐ ู ุง ุดุงุก ุงููู
ู
ุฑุญุจุง ุฌูุฒูู
ููู ุฃุฎุจุงุฑูุ
ุงุณุชุจุฏูุช
IN
ูู ุงูุนุจุงุฑุฉ ุงูุณุงุจูุฉ ุจู
SELECT
ูุฃุตุจุญุช ููุฐุง
AND(
SELECT(schedule[date-m],
[date-h] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงููุฌุฑู]),
ISBLANK(
FILTER(Agenda, AND(
[ุงูู
ุฏุฑุณุฉ] = [_ThisRow].[ุงูู
ุฏุฑุณุฉ],
[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]
))
- LIST([_ThisRow])
+ FILTER(twiceWeeklyVisits, AND(
[ุงูู
ุฏุฑุณุฉ] = [_ThisRow].[ุงูู
ุฏุฑุณุฉ],
ISOWEEKNUM([ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู]) = ISOWEEKNUM([_ThisRow].[ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู])
))
)
)
ูููู ูุนุทููู ุฎุทุฃ ูู ู ู ุงูู ู ูู ู ุฑุงุฌุนุชูุงุ
ูู ุชุญูุงุชู
ุญูุงู ุงูููุ
ูู ุงุฐุงุ ู ุง ุงููุฏู ู ู ูุฐุง ุงูุงุณุชุจุฏุงูุ
ุงูุฎุทุฃ ุทุจูุนู ูุฃู ูู ุงูุชุนุจูุฑุงุช ุงูู
ุดู
ููุฉ ุฏุงุฎู
AND()
ูุฌุจ ุฃู ููุฑุฌูุน ูู ู
ููุง ููู
ุฉ ู
ูุทููุฉ: ุตุญูุญ ุฃู
ุฎุทุฃุ ูู ุญูู ุฃู ุงูููู
ุงูุชู ูุชู
ุฅุฑุฌุงุนูุง ู
ู ุงูุชุนุจูุฑ ุงูุฐู ุฃุฏุฎูุชูู ูู ุชุงุฑูุฎ..
ุงูุชุนุจูุฑ ุฏุงุฎู
IN
ูุง ูุนู
ู ุจุดูู ุตุญูุญ ููู ูุง ูุฌูุจ ุงูุชุงุฑูุฎ ุชููุงุฆูุง ู
ู ุงูุฌุฏูู
schedule
ูุฐูู ูู
ุช ุจุงุณุชุจุฏุงูู
ุงููุฏู ู ู ุงูุชุนุจูุฑ ูู ููู ุฌูุจ ุงูุชุงุฑูุฎ ุชููุงุฆูุงู ู ู ุงูุฌุฏููุ ุจู ูุตุฑ ุงูุชูุงุฑูุฎ ุงูู ุชุงุญุฉ ูุงุฎุชูุงุฑ ู ูุนุงุฏ ุงูุฒูุงุฑุฉุ ุนูู ุงูุชูุงุฑูุฎ ุงูู ุดู ููุฉ ุถู ู ุงูุฃูุงู ุงูุฏุฑุงุณูุฉ ูู ุงูุนุงู ุงูุฏุฑุงุณู..
ุจุงูุฅุถุงูุฉ ุฅูู ุฃู ุญูู
Valid if
ูุง ูู
ูู ุงุณุชุฎุฏุงู
ู ุฅูุง ููุฐุง ุงูุบุฑุถ: ุงูุชุฃูุฏ ู
ู ุตูุงุญูุฉ ุงูููู
ุงูู
ุฏุฎูุฉ ุฃู ูุตุฑูุง ุนูู ูุงุฆู
ุฉ ู
ุญุฏุฏุฉ
ูู ููุงู ุทุฑููุฉ ูุฌูุจ ุงูุชุงุฑูุฎ ุชููุงุฆูุง
ุจุงูุฅุถุงูุฉ ุฅูู ุฅูู ูุตุฑ ุงูุชูุงุฑูุฎ ุงูู
ุชุงุญุฉ ูุงุฎุชูุงุฑ ู
ูุนุงุฏ ุงูุฒูุงุฑุฉุนูู ุงูุชูุงุฑูุฎ ุงูู
ุดู
ููุฉ ุถู
ู ุงูุฃูุงู
ุงูุฏุฑุงุณูุฉ
ูุฐุง ุงูุชุนุจูุฑ
SELECT(schedule[date-m],
[date-h] = [_ThisRow].[ุงูุชุงุฑูุฎ ุงููุฌุฑู])
ูุนู
ู ู
ุนู ุฌูุฏุงู ูู ุญูู
Valid if
ููู ูู
ุงุณุชุทุน ุฃู ุฃุฌู
ุน ุจููู ูุจูู ุงูุชุนุจูุฑ ุงูุฐู ูุชุจุชู ุฃูุช
ูุนู ุฐูู ู ู ููุ ูููู ู ุง ูู ุงููุงุนุฏุฉ ุงูุชู ุชุฑูุฏ ุฌูุจ ุงูุชุงุฑูุฎ ุนูู ุฃุณุงุณูุงุ ูุฏูู ูุงุฆู ุฉ ู ู ุงูุชูุงุฑูุฎ ุงูุตุงูุญุฉ ููุงุฎุชูุงุฑุ ูุชุฑูุฏ ุฌูุจ ุฃุญุฏูุง ุชููุงุฆูุงูุ ุฃู ุชุงุฑูุฎ ู ู ุชูู ุงููุงุฆู ุฉ ุชูุฏ ุฌูุจูุ
ุจุบุถ ุงููุธุฑ ุนู ุตุญุฉ ุงูุชุนุจูุฑ ุงูุฐู ูุชุจุชููุ ุฑุจู ุง ูู ูููู ุงุณุชูุชุงุฌ ุฃูู ุชุฑูุฏ ุฃู ูููู ุงูู ุณุชุฎุฏู ุจูุชุงุจุฉ ุงูุชุงุฑูุฎ ุงููุฌุฑูุ ููููู ุงูุชุนุจูุฑ ุจุฌูุจ ุงูุชุงุฑูุฎ ุงูู ููุงุฏู ุงูู ูุงุจู ูู ุชููุงุฆูุงู.. ูู ูุฐุง ูู ุงูุบุฑุถุ
(ุฑุจู
ุง ูู
ูููู ุงุณุชูุชุงุฌ ุฃูู ุชุฑูุฏ ุฃู ูููู
ุงูู
ุณุชุฎุฏู
ุจูุชุงุจุฉ ุงูุชุงุฑูุฎ ุงููุฌุฑูุ ููููู
ุงูุชุนุจูุฑ ุจุฌูุจ ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู ุงูู
ูุงุจู ูู ุชููุงุฆูุงู)
ุจุงููุนู ูุฐุง ูู ุงูู ุทููุจ ๐
ู ุง ูุนููุงู ุญุชู ุงูุขู:
ุงููุชูุฌุฉ ุงูููุงุฆูุฉ ูู ุงูุญุตูู ุนูู ูุงุฆู ุฉ ู ู ุงูุชูุงุฑูุฎ ุงูุตุงูุญุฉ ููุงุฎุชูุงุฑุ ููุฐู ุงูุชูุงุฑูุฎ ูู ุชูุงุฑูุฎ ู ููุงุฏูุฉ..
ุฅุฐุง ูุงู ุงูู ุณุชุฎุฏู ุจูุชุงุจุฉ ุงูุชุงุฑูุฎ ุงููุฌุฑู ูุฏููุงู ูุฑุจู ุง ูููู ุงูุชุงุฑูุฎ ุงูู ููุงุฏู ุงูู ูุงุจู ุถู ู ุงููุงุฆู ุฉ ุงูุตุงูุญุฉ ููุงุฎุชูุงุฑุ ุฃู ูุงุ ููู ูุฐู ุงูุญุงูุฉ ุฅุฐุง ูุงู ุงูุชุงุฑูุฎ ุงูู ููุงุฏู ุงูู ูุงุจู ุบูุฑ ุตุงูุญ ููุงุฎุชูุงุฑ ุณุชุธูุฑ ุฑุณุงูุฉ ุฎุทุฃ ูุณูุชูุฌุจ ุนููู ุชูุฑุงุฑ ุงูู ุญุงููุฉ ู ุฑุงุฑุงู ุญุชู ุชุฎุชูู ุฑุณุงูุฉ ุงูุฎุทุฃ.. ูุง ุฃุฑู ูุฐู ุงูุทุฑููุฉ ุญูุงู ุนู ููุงู ููุงุฌูุฉ ุงูู ุณุชุฎุฏู ..
ูููู ูู ููู ุงูู ุญุงูุธุฉ ุนูู ุงูุชุนุจูุฑุงุช ูู ุง ูู ุจุญูุซ ุชุนู ู ุนูู ุงูุชูุงุฑูุฎ ุงูู ููุงุฏูุฉุ ุจููู ุง ูุชู ุฅุธูุงุฑ ูุงุฆู ุฉ ุงูุชูุงุฑูุฎ ุงููุฌุฑูุฉ ุงูุตุงูุญุฉ ููุงุฎุชูุงุฑ ููู ุณุชุฎุฏู .. ูู ุงููุงูุน ุณูููู ุงูู ุณุชุฎุฏู ูุฏ ูุงู ุจุงุฎุชูุงุฑ ุชุงุฑูุฎ ู ููุงุฏูุ ูููู ู ุง ุณูุธูุฑ ูู ูู ุงูุชุงุฑูุฎ ุงููุฌุฑู..
ูู ูุฐุง ูู ุงูุบุฑุถุ
ุงูุบุฑุถ ูู ุง ุฐูุฑุช
ููู ูู ุชุฑุชูุจู ุฃูุง ุณูููู
ุงูู
ุณุชุฎุฏู
ุจุงูุงุฎุชูุงุฑ ุนูู ุงููุญู ุงูุชุงูู
ุงููุตู ุงูุฏุฑุงุณู
ุจุนุฏ ุฐูู ุณูุธูุฑ ูู
ุงูุฃุณุงุจูุน
ุซู
ุชุธูุฑ ูู
ุงูุฃูุงู
ุซู
ูุธูุฑ ูู
ุงูุชุงุฑูุฎ ุงููุฌุฑู
ุซู
ูุธูุฑ ูู ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู
ุญุณูุงู.. ุงุณุชู ุฑุงุฑุงู ูู ุง ุทุจููุงู ูู ุงูุณุงุจูุ ูู ุง ุดุฑุญุชูุ ูู ูููู ุจุฅุฌุฑุงุก ุชุบููุฑุงุช ุนูู ุงูุชุนุจูุฑุงุชุ ูููู ู ุง ุณูููู ุจุชุบููุฑู ูู ุฅุธูุงุฑ ุงูุชูุงุฑูุฎ ุงูุตุงูุญุฉ ููุงุฎุชูุงุฑ ู ู ุงูุชูุงุฑูุฎ ุงููุฌุฑูุฉ ุจุฏูุงู ู ู ุงูุชูุงุฑูุฎ ุงูู ููุงุฏูุฉุ ูุจุนุฏ ุงุฎุชูุงุฑ ุงูุชุงุฑูุฎ ุงููุฌุฑู ุณูููู ุงูุชุทุจูู ุจุฅุธูุงุฑ ุงูุชุงุฑูุฎ ุงูู ููุงุฏู ุงูู ูุงุจู..
ุณูููู ุจุฅุถุงูุฉ ุฌุฏูู ุชุญููู ุงูุชูุงุฑูุฎ ุงูุฐู ุฃุฑููุชูู ูู ุชุนููู ุณุงุจู ููุ ุจุนุฏู ุง ุณุฃูุชู ุนู ุงูุทุฑููุฉ ุงูุชู ุชููู ุจูุง ุจุชุญููู ุงูุชูุงุฑูุฎ ุจูู ุงูุชูููู ุงูู ููุงุฏู ูุงููุฌุฑูุ ุฅูู ุงูุชุทุจูู..
Key ูู ูุฐุง ุงูุฌุฏููุ ุญูู ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู ุณูููู ู
ู ููุน ุชุงุฑูุฎ ูุณูููู ูู ู
ูุชุงุญ ุงูุฌุฏูู
Label ุฃู
ุง ุญูู ุงูุชุงุฑูุฎ ุงููุฌุฑู ูุณูููู ูู ุงููุณู
Ref ุณูููู
ุจุชุบููุฑ ููุน ูู ุญููู ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู ูู ูู ุงูุฌุฏุงูู ุงูุฃุฎุฑู ุฅูู ููุน ู
ุฑุฌุน
ู
ุดูุฑุงู ุฅูู ุฌุฏูู ุชุญููู ุงูุชูุงุฑูุฎ
ูููุฐุง ุณุชุธูุฑ ุงูุชูุงุฑูุฎ ุงููุฌุฑูุฉ ู ุญู ุงูุชูุงุฑูุฎ ุงูู ููุงุฏูุฉ ูู ูู ุตูุญุงุช ุงูุชุทุจููุ ูู ุญูู ุงูุชุงุฑูุฎ ุงูู ููุงุฏูุ ูููุง ุณูุชูุฌุจ ุนูููุง ุฅุธูุงุฑ ุงุณู ุฌุฏูุฏ ูุฑุงู ุงูู ุณุชุฎุฏู ุจุฏูุงู ู ู ุงุณู "ุงูุชุงุฑูุฎ ุงูู ููุงุฏู".. ูู ูููู ุจุชุบููุฑ ุงุณู ุงูุญูู ุจู ุณูููู ููุท ุจุชุบููุฑ ุงูุงุณู ุงูุฐู ูุฑุงู ุงูู ุณุชุฎุฏู .. ุฃูุถุงู ูู ุงููุงูุน ุณูุชู ุงูุงุฎุชูุงุฑ ุจูุงุกู ุนูู ุงูุชูุงุฑูุฎ ุงูู ููุงุฏูุฉ ูููุณุช ุงููุฌุฑูุฉุ ูููู ุงูู ุณุชุฎุฏู ุณูุฑู ุจุฏูุงู ุนููุง ุงูุชูุงุฑูุฎ ุงููุฌุฑูุฉ..
Display Name ูุฐููุ ุฏุงุฎู ุญูู ุงูุชุงุฑูุฎ ุงูู
ููุงุฏู ุณูููู
ุจุงูุฐูุงุจ ุฅูู ุฎุงูุฉ
ููุถุน ุจุฏุงุฎููุง ุนููุงู "ุงูุชุงุฑูุฎ ุงููุฌุฑู"ุ ููุฐุง ู
ุง ุณูุฑุงู ุงูู
ุณุชุฎุฏู
..
ูุชูุฌุฉ ุงูุชุบููุฑ ุงูุฐู ูู ูุง ุจู ูู ุธููุฑ ุงูุชูุงุฑูุฎ ุงููุฌุฑูุฉ (ุงููุณู ) ุจุฏูุงู ู ู ุงูู ููุงุฏูุฉ (ุงูู ูุชุงุญ) ูู ูู ุญููู ุงูุชูุงุฑูุฎ ุงูู ููุงุฏูุฉ ุงูุชู ูู ูุง ุจุชุบููุฑ ููุนูุง ุฅูู (ู ุฑุฌุน)ุ ูู ุฌู ูุน ุงูุฌุฏุงูู..
ูุฅุธูุงุฑ ุงูุชุงุฑูุฎ ุงูู
ููุงุฏูุ ุณูููู
ุจุฅุถุงูุฉ ุญูู ุฌุฏูุฏ ูู
ูู ุฃู ูููู ุงูุชุฑุงุถูุงู ู
ู ููุน ุชุงุฑูุฎ
App Formula ูุณูููู
ุฏุงุฎูู ุจูุถุน ุงูุชุนุจูุฑ ุงูุชุงูู ูู ุฎุงูุฉ
[ุงูุชุงุฑูุฎ ุงูู ููุงุฏู].[ุงูุชุงุฑูุฎ ุงูู ููุงุฏู]
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |