How to enable Javascript

Latest Posts

Removing duplicate fields (emails as example) solution
for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!=1 do delete last(select Table_Name where Email_field = text(i)) end end Enjoy!
- agiorno
- agiorno
- updated 11 mths ago
- 1reply
- 716
- 1
- Learn & Share
Re: Constrain an array Birger, it doesn`t work neither with staitetment nor values. even when i try if not(5 in [1,3] ) then - it always alert "symbol expected:then"
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Constrain an array
Hi friends! i have a table with a lot of records. I have an array of numbers which is result of some formula. In the Constraint field i want avoid record which id contains in array.…
- agiorno
- agiorno
- 3 yrs ago
- 3replies
- 1,028
- Get help
Trigger after update strange behavior
I have 3 number fields. Each of them have Trigger After Update(TAU) which change next number. As example: TAU number1 is number2:=99 TAU number2 is number3:=55.…
- agiorno
- agiorno
- 3 yrs ago
- 1reply
- 1,051
- Get help
Re: Array Index prüfen? Hi Jörg! May you explain how to use this: if myWochentag in [ArrayWochentage] then —- because when I try something like let myArray:=[1,2,3,4.5]; let y :=5; if y in [myArray] then...…
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates? Sean, yes I have. When I create record I always fill date field. I want to calculate an array of dates in which I have not any record. Usually date != today.
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates? Sean, I find myself in another issue which related with previous one. Now I have two arrays. First contains all dates in period, Second contains dates that I want exclude. concat(firstArray) => 24.04.…
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates? Thank you very much!
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates? Sean, thank you! It’s exactly what I want. Works great! May you explain logic of this part: dateArray := unique(dateArray, today() + i) I want better understand how use it in another case.…
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
How to show all dates between two dates?
Hi everyone! I really can’t find the solution without creating additional table. Example: let myArray := [today(), (today+2)]=> 23.04.19, 25.04.19 but what about 24.04.…
- agiorno
- agiorno
- 3 yrs ago
- 9replies
- 2,359
- Get help
Re: Somewhere to share user templates? And could you add me too?:)
- agiorno
- agiorno
- 3 yrs ago
- Learn & Share
- Reported - view
Re: how calculate date from year, week number and weekday? Dear Sean! Thank you so much! I want to describe my goal. There are 4 doctors in clinic. All of them have different schedules depending on weeks( odds or even).…
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: how calculate date from year, week number and weekday? Sean! Thank you for your respons! Unfortunately it works incorrectly. In my case Weekday=0 means Monday, but your code turns it to day number. Actually I need calculate date for each Friday in 2019…
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
Re: how calculate date from year, week number and weekday? I mean, I don’t know how to make it correct, that example obviously doesn’t work lol
- agiorno
- agiorno
- 3 yrs ago
- Get help
- Reported - view
how calculate date from year, week number and weekday?
Date:= year(2019)+week(14)+weekday(0)
- agiorno
- agiorno
- 3 yrs ago
- 13replies
- 4,126
- Get help

agiorno

agiorno

15
1
0

Joined: 07 Jul 2017

Follow