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: BUTTON
Copy the icon to the clipboard and then paste it to the button name.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
@Mconneen, yeah I spent most of my evening just trying to get the script working. One of my unanswered questions before I had to turn my brain off was how do you get more than one record without…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
Nice timing Steven :) One of the problems with this approach is now your array values are text instead of number and if you want to do any arithmetic with the values you will have to convert them to…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I add two arrays?
I'm not sure why the Ninox team made array manipulation so difficult. It's like they wanted arrays to be read-only after the arrays are defined. One way is to break the arrays down and then rebuild…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
I see what you're saying now. I tried it with item() and it comes up blank. The documentation does say Lookup a single Record so I guess it finds the first record that matches the criteria and that's…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Save archive as... crashes Ninox
The “Save as...” is available in the Mac app, but not the iPad app. I get the same option as you describe on the iPad app “Store on iCloud Drive”. When you choose “Open in...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Basics
Nah, I wouldn’t look at it that way. You only have to learn Ninox commands and syntax and some of that is similar. :) You could also try, ((select address) where 'xmas card ind' = 2).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Basics
Try, ((select address)['xmas card ind' = 2]).'xmas card ind' This reference might help you understand Ninox a little better.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Can I place a comment in a script?
Wow, I’m pretty sure the Ninox team is going to put this on the top of their todo list now you’ve made the exact same request 4 times.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: create formatted content for a rich text field
You can use the fn key + Space, Tab or Return in a formula in Print Layout and it will work. To assign formatted text to a Rich Text field you'll have to use the html() function.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
Per the documentation... "The response consists of an array of records. Each record has the following common attributes:" I would try the following to get the string representing the second record...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
I think I follow... Did you try item(json, 1) or some other index?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox HTTP Calls syntax
@Mconneen, I don’t have any experience with this, but if it is returning more than one record it would stand to reason that you would need access the different items like you would an array using…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Linking tables
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-link-automatically-via-a-function-fields-in-two-tables-that-contain-the-same-text-5c6aaf80e850ad238982b496
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: list of values
You bet!
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: dd/mm/yyyy
I don’t have any experience with the cloud version, but it’s strange that the system and browser settings don’t fix the problem. Support eventually answers questions that users don’t.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: list of values
Hi Tacho, here you go let myMC := sort(chosen('Multiple choice'));let myMCCount := count(myMC);let myText := "";for i in range(0, myMCCount) domyText := myText + "- " + item(myMC, i) + ""end;Text :…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: dd/mm/yyyy
If you do an internet search using your preferred search engine, you will find explanations for changing the date format for most browsers.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: transform text field into selection dropdown field
You can’t change a field type. You have to create a choice field and copy the value of the text field to the choice field. You can delete the text field afterwards if you want.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: list of values
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: list of values
When you say "document", do you mean Form or Print Layout? I went with Form and used this code in the Table's "Trigger after update"... let myMC := chosen('Multiple choice');let myMCCount :…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: won't let me edit a field
It shouldn't be a problem as long as it's a Text field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
You're welcome. I'm glad you got it working Pierre. :)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Where did you put the formula? The button needs to be placed on the ENTITIES form and the formula goes in the button. The error you got seems similar to one you would get from a formula field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
I'm not sure what distinction you are making here... "massively if possible, if not with a button". The code you enter into the button formula is for a massive update,…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 57 58 59 60 61 71

Welcome to the Ninox community

Sean

My Posts

Re: BUTTON

Re: Ninox HTTP Calls syntax

Re: How can I add two arrays?

Re: How can I add two arrays?

Re: Ninox HTTP Calls syntax

Re: Save archive as... crashes Ninox

Re: Basics

Re: Basics

Re: Can I place a comment in a script?

Re: create formatted content for a rich text field

Re: Ninox HTTP Calls syntax

Re: Ninox HTTP Calls syntax

Re: Ninox HTTP Calls syntax

Re: Linking tables

Re: list of values

Re: dd/mm/yyyy

Re: list of values

Re: dd/mm/yyyy

Re: transform text field into selection dropdown field

Re: list of values

Re: list of values

Re: won't let me edit a field

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Overview