Sean's Profile | Ninox Community

Latest Posts

Re: How to show all dates between two dates?
Agiorno, something like the following is the only thing I can work out... let dateArray := [today()];for i from 1 to 5 dodateArray := unique(dateArray, today() + i)end;let firstArray :…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates?
Agiorno, Do you have a pattern or rule you are using to exclude dates?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to show all dates between two dates?
Agiorno, you're welcome. The unique() function allows you to combine arrays and add items to arrays as long as they are unique. The function will remove duplicate items.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Determine Multiple Choice baed on other field
"End" should be "end"
- Sean
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: BUTTON TO SWITCH CONTENT OF POPUP
Use closeRecord() before you use popupRecord().
- Sean
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Custom made Icons
Jörg, % and numbers() come to mind 😬 Sean
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: sum values for a specific data
I think text('Product ID') will also work
- Sean
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Multiple choice picks in order?
@Mconneen, Have you worked out the logic yet? ;)
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 53 54 55 56 57 71

Welcome to the Ninox community

Sean

Re: How to show all dates between two dates?

Re: How to show all dates between two dates?

Re: How to show all dates between two dates?

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?

Overview