Sean

1762
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Script to find and return duplicate records that already exist
@Maria, Do you want to automatically mark records as duplicates or delete duplicate records?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Reviewing duplicates in one field
This should work... let t := this;if cnt(select 'Duplicate Test' where ItemID = t.ItemID) > 1 then"Duplicate"else"Unique"end
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Script to find and return duplicate records that already exist
It's late for me so maybe I'm missing something, but I think you would need to use the "delete" command in order to delete a record.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
The code in my previous post is a poor representation of the concise power of Regular Expressions and the functions that use them. The following line does the same thing...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
@Steven, I guess I need to refresh the page before I post
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
You have the assignment ":=" and comparison "=" operators reversed. It should be... if 'Com. %' = 1 and Com := 'Total Fees'*0.1 The switch statement also works here...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
You would need to create a Formula field with the parsed Location field information and sort by the formula field. This formula works... let myAddress := text(Location);let addressRegex := "(\d+) (.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
I rarely print, but thought I'd try it. This is what I see in Print layout mode... ...and this is what I get when I print all 59 pages on every page...
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Steven,
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
I have to say that my complaint is more about functions/functionality that have not been documented at all! I'm beginning to wonder if those in charge of documenting these things are unable to keep…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
@Steven, I hope you don't mind me submitting an alternative solution. I saw this post last night, but was too tired to respond. length(replacex(Text, "[^#]", "g",…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Limit Dropdown choices based on another field
That is not available, but it would be a nice feature. The workaround is to create different Choice fields based on your criteria and show/hide the fields based on that criteria.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to distribute build application?
I'm not sure if this is what you want... https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/how-commercialize-a-template-5cac6e298bca703bc3df9a0a
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
I bet they implement drag and drop for Tabs and the associated fields before they release an updated user manual
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
I especially like this part...
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: The online user manual
Mel, This has been an ongoing complaint/issue. You might want to look at this thread...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Incrementing date in a script
Jack, Here are a couple of links that may help... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/date-fields-and-timezones-issue-unix-vs-utc-conflict-5b7462cc03f12310870ad569?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Calculating a sell price in edit field without using a formula field
Mel, You're welcome. I think being able to use a formula as the "Default value" would be a great feature request. Ninox Team what do you think?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Incrementing date in a script
Jack, Glad you got it working. The only time I work with Appointment fields is when I'm trying to help someone on the forum. Since you wanted to use a loop to create new records with appointments,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Calculating a sell price in edit field without using a formula field
I think what you need isn't available. If "Default value" accepted a formula instead of a number only, you would enter your formula there. I don't think "Triggers" would work unless you are just now…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Incrementing date in a script
You need to use milliseconds to modify an Appointment value... let myN := 86400000 * 7;start(Appointment) + myN
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Incrementing date in a script
Well, the title did say "Incrementing date in script" so I assumed it was a Date field ;-). I haven't spent much time working with the Appointment field,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to populate a multiple choice field from a text field?
You can assign the values. Did you create a "Choice" field or "Multiple Choice" field?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Incrementing date in a script
Hopefully you already figured this out... let new := (create 'Lesson Schedule'); ...needs to be inside the loop. I was using a variable instead of creating records when I was testing.…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 39 40 41 42 43 71

Welcome to the Ninox community

Sean

My Posts

Re: Script to find and return duplicate records that already exist

Re: Reviewing duplicates in one field

Re: Script to find and return duplicate records that already exist

Re: How to Sort Localisation fields properly ?

Re: Choice field and formula

Re: Choice field and formula

Re: How to Sort Localisation fields properly ?

Re: Have a Page number on the Print document

Re: If a text field has > 30 '#' then show alert

Re: The online user manual

Re: If a text field has > 30 '#' then show alert

Re: The online user manual

Re: Limit Dropdown choices based on another field

Re: How to distribute build application?

Re: The online user manual

Re: The online user manual

Re: The online user manual

Re: Incrementing date in a script

Re: Calculating a sell price in edit field without using a formula field

Re: Incrementing date in a script

Re: Calculating a sell price in edit field without using a formula field

Re: Incrementing date in a script

Re: Incrementing date in a script

Re: Is it possible to populate a multiple choice field from a text field?

Re: Incrementing date in a script

Overview