Announcements
This code is not working but I can't understand the reason. 😕This is basically Vacation Program. What is the problem of this code?
ForAll( Gunler; If( Text(Value) <> "1.01.2001"; Patch( PSY; Defaults(PSY); { Kişiler: Text(User().FullName); Başlık: "İzinli"; Proje_Saati: "9"; Tarih: Value; Faaliyet: "İzin"; Lokasyon: "Ev" } ) ) ) & Navigate(AnaEkran) & Reset(TarihSeçimi_1) & Reset(TarihSeçimi_2) & Set(Gorunurler; 0)
Hi @tguckiran ,
It seems that Patch() is Right.
I consider Text(Value) <> "1.01.2001" is wrong.
May I ask what is the "Gunler" in your formula?
Best Regards,Tina
It is the Turkish word which means "days".
Hi @tguckiran ,
May I ask what's in this table, and what are the field types?
Set(Gunler; ForAll(Sequence(TarihGorevBaslangic-TarihIzinBaslangic); If(Weekday(TarihIzinBaslangic + Value - 1) in [2; 3; 4; 5; 6]; TarihIzinBaslangic + Value - 1; "-1")))
I will share code for "Gunler",
According to your formula, we made a sample for you.
You can double Click "ForAll" and to see what data in the "Gunler" .
Take the data I'm currently showing as an example, please try this:
ForAll( Gunler; If( Text(Value) <> "1/1/2001, 12:00:00 AM"; Patch( PSY; Defaults(PSY); { Kişiler: Text(User().FullName); Başlık: "İzinli"; Proje_Saati: "9"; Tarih: Value; Faaliyet: "İzin"; Lokasyon: "Ev" } ) ) ) & Navigate(AnaEkran) & Reset(TarihSeçimi_1) & Reset(TarihSeçimi_2) & Set(Gorunurler; 0)
Hope this will help you,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289