Sean

1760
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: How to show all dates between two dates?
agiorno, Here are a couple of options... Option 1 let dateArray := [today()];for i from 1 to 3 dodateArray := unique(dateArray, today() + i)end;format(item(dateArray, 0), "DD/MM/YYYY") + ",…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Determine Multiple Choice baed on other field
wynand, You can attach this code to a button and it will update existing records... for r in select YourTable doif r.EU = 1 then r.('EVG Sales Regions' := unique(numbers(r.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Determine Multiple Choice baed on other field
"End" should be "end"
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Determine Multiple Choice baed on other field
You can use something like this... 'EVG Sales Regions' := unique(numbers('EVG Sales Regions'), 1) for Europe 'EVG Sales Regions' := unique(numbers('EVG Sales Regions'), 2) for UK,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Filter a View to show only Top 5
Nick, I think you will need to do something similar to this thread...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Automatic selection of record from linked table
Noel, If I understand correctly, you can use this... Sales := 1 in "Trigger on create" in the nominal ledger table. This automatically selects the first and, I'm assuming,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering select statements with “choice" fields
You can do it using the text() function... (select inventory where text(category) = "Oil").item or (select inventory)[text(category) = "Oil"].item
- Sean
- 5 yrs ago
- Get help
- Reported - view
Can you join a Webinar that's already started?

I'd like to join the Webinar next Tuesday, but I have an appointment that I must keep. If I did the time zone conversion correctly, it starts at 11:00am CDT and I will likely not be able to join…
- Sean
- 5 yrs ago
- 1reply
- 1252
- Get help
Re: right syntax of a trigger with double condition
Use "and" instead of the comma... let jj := cnt('3. Commissioni'.'Elenco Workflow (tutti)'['TODO.2' = 31 and CHIUSURA = null]); Similar to your if-condition.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: BUTTON TO SWITCH CONTENT OF POPUP
Use closeRecord() before you use popupRecord().
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can you relate existing databases, filled with records, in a quick and efficient way?
Hi Marcel, you’re welcome. Yeah, the prospect of linking a bunch of records one at a time isn’t very appealing! Sean
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can you relate existing databases, filled with records, in a quick and efficient way?
Marcel, Take a look at this thread and see if it helps...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Can I move items from one table to another?
@Mconneen-sensei, Even though this is possible, it might make more sense design-wise to have a Choice field with Fridge and Freezer options and then filter on that field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
For anyone that is interested this is a version that I'm a little happier with... "// Initialize variables";let curChosenText := OPChosen;let curChosenArray := split(OPChosen, "|");let curCount :…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I increase the number of results given by the search engine?
If you are using the API you can change the "perPage" value. I don't have much experience with this so I don't know if that will do it. The quantity you are getting is the default "perPage" value.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Custom made Icons
Jörg, % and numbers() come to mind Sean
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: sum values for a specific data
I think text('Product ID') will also work
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, The separate table approach would be pretty handy if someone wanted to timestamp the different picks.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@gsechi, I don't know if you are interested, but here is a solution that works for selection and deselection. It requires a Text field to store the ordered Multiple Choice selection/deselection and…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
Ooops, forgot to mention that the code goes in the "Trigger after update" for the Multiple Choice field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, Hmmm, I guess I'm not seeing the single Choice solution unless you have one Choice field for every Multiple Choice option. I tried using a separate table to store the Multiple Choice…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, Have you worked out the logic yet? ;)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, yeah, this one truly is an Easter egg. I searched for it in the Reference page and didn’t find it. First time I heard of it was here... https://ninoxdb.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, it should be numbers() not number()
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Auto Numbering Issue
I'm going to make some assumptions... 1) 'Work Order Master Code' is stored as a number since you are using the text() function 2) Each Submittal has a unique date 3) Work Orders can span multiple…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 53 54 55 56 57 71

Welcome to the Ninox community

Sean

My Posts

Re: How to show all dates between two dates?

Re: Determine Multiple Choice baed on other field

Re: Determine Multiple Choice baed on other field

Re: Determine Multiple Choice baed on other field

Re: Filter a View to show only Top 5

Re: Automatic selection of record from linked table

Re: Filtering select statements with “choice" fields

Can you join a Webinar that's already started?

Re: right syntax of a trigger with double condition

Re: BUTTON TO SWITCH CONTENT OF POPUP

Re: How can you relate existing databases, filled with records, in a quick and efficient way?

Re: How can you relate existing databases, filled with records, in a quick and efficient way?

Re: Can I move items from one table to another?

Re: Multiple choice picks in order?

Re: How can I increase the number of results given by the search engine?

Re: Custom made Icons

Re: sum values for a specific data

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Multiple choice picks in order?

Re: Auto Numbering Issue

Overview