0
Data Field Types
Hi, I'm trying to use this Db for the first time on a mini-Ipad, I'm trying to use the data field "location" but I cannot find any instruction on the on line help.
I put the field in a form, when I click on it, a map comes out, find an address, click on save thinking that it will appear on the field, but nothing happened.
I added a text field, wrote on it an address, edit the location field adding aa command "location=address" but again nothing happens. Can someone please help me to understand? Thanks
I put the field in a form, when I click on it, a map comes out, find an address, click on save thinking that it will appear on the field, but nothing happened.
I added a text field, wrote on it an address, edit the location field adding aa command "location=address" but again nothing happens. Can someone please help me to understand? Thanks
Like Follow
90replies
-
Hi,
sorry, in the german version are _id to Nr.
Leo -
Hi Leo,
No worries, I'm just trying to learn as much as I can and get up to speed on this coding language & protocols.Im an old MS Access database developer so this is a whole new programming language for me.
Thanks for the reply and any tips n tricks you would like to pass my way are greatly appreciated.
Jon -
Thanks Alexander,
The create table_name creates a new record but the previous one is still displayed with the filled fields.
How can I skip automatically to the new empty record ? -
Hello, you can use openRecord or popupRecord. Find more info: http://manual.ninoxdb.de/en/function-and-language-reference/
Best regards, Alex -
Hello. Loving Ninox so far! Keep up the good work!
My question is: Is there a way to edit a field so that I can create a slider, or a slider bar, or even a double slider? For example we are using it to enter a price range for customers, anywhere from $5,000-$500,000. I'd like to be able to make a range of options.
If not, what would you suggest as a workaround? Would I create two fields and use a "from ___to___" option? -
Hello Jmorang,
the best option is to use two fields for a range. We take your idea of a slider on the change request list. but we cannot say exactly when we implement it.
Best regards, Alex -
Thanks. It perfectly works.
Otherwise, i would like to display a quite large text on the right side of the form. This text (or image) should not be of course a field of the data base but only a commitment to read before signing.
How can I paste this text on my form across the fiels rows? -
Hello Lebertre,
you can use layout elements such as headings to insert consistent text for all records. More feature are planned.
Best regards, Alex -
Dear all,
I've made a list of 50 questions, with always the same "radio-buttoned" answers (Fieldype "Choice"). Is it possible to copy the data field (and the radio-buttoned answers)?
Tks in advance,
Erik -
Hi Erik, we have this feature on the change request list. This will enable to create global choice lists. But we cannot say exactly when we implement it.
Best regards, Alex -
I have the same request - for multiple choice fields. Thank you.
-
Hello Andrew,
we have this feature on the change request list. As an alternative you can create a second table with all the choice values. Create on more "link" table and link it with both.
You can also drop a line to support@ninoxdb.de. We are glad to help.
Best regards, Alex -
Hallo,
gibt es eine Möglichkeit Datumsfelder so zu filtern oder zu suchen für einen bestimmten Bereich. Beispiel im Rechnungsmodul will man sich nur die Rechnungen für das erste Quartal anzeigen lassen. Finde nur die möglichkeit sich das ganze Jahr oder den einzelnen Monat. -
Hallo,
verwenden Sie folgende Funktion:
yearquater('Datumsfeld')
Gruß
Birger - Ninox Support -
Hello, is that possible to make "multiple choices" field ?
For exemple, i want to make a field with all the months (jan, fev, apr...) and i want to select multiple choices.
Thanks -
At the moment it is not possible to have multiple choices from a choice field. You'd have to have a seperate table with the choices and create a relation from you original table to this choices table.
Greetings
Birger - Ninox Support -
Is there any possibility to make Unique number field.
Now in table is column with Global unique ID, I want to make my own unique ID.
When user type number witch exist in table, then system display error message.
This field must be required so empty value is not allowed. -
This is possible.
1. with a trigger "onCreate" on table level with this formua:–––
uniqueNumber := max((select Table1).uniqueNumber) + 1
–––
or - if you just want to check if the number is unique after update put this formula to the "onAfterUpdate" trigger of the field:–––
let myTest := 'Auto increment Number';
if cnt(select Table1[uniqueNumber = myTest])>1 then "not unique" else myTest
–––
Birger - Ninox Support -
Thanks :)
-
Hello,
How to add a carriage return by programming in a multi-line field?
Thanks -
Lets say there is a field "firstName" and "lastName". Here is a formula:
–––
"Hello " + firstName + " " + lastName + ",
thanks for your mail."
–––
The result yould be somthing like this:
Hello Robert Jones,
thanks for your mail.
So to get a CR give a CR in "". -
thanks,
And how i write programmatly a CR?
Supose a variable myText. This variable set à field text multiline, and i want to write multiline.
My code :
let myTexte := "Robert Jones," + "CR" + " thanks for your mail."
myFieldTextMultiLine = myTexte;
How i write the CR in my code?
Thanks -
–––
let myTexte := "Robert Jones,
thanks for your mail."
myFieldTextMultiLine = myTexte
–––
Just enter a CR into a string.
Birger - Ninox Support -
waouuu
thanks very much
nice support
best regards
robert -
Hello.
Is there a way to check on the value of a "Choice" field?
I have a Choice field with three possible values. (with icons and different colors).
When I try to build an if/then structure, I get an error saying that the field has different values.
Thanks!