Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
1
reply
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
3
replies
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
1
reply
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
9
replies
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
13
replies
4,126
Get help
agiorno
agiorno
15
1
0
Joined: 07 Jul 2017
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags