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
90replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi,
    sorry, in the german version are _id to Nr.

    Leo
    Like
    • jonfusa
    • jonfusa
    • 6 yrs ago
    • Reported - view
    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
    Like
    • Lebertre
    • Lebertre
    • 6 yrs ago
    • Reported - view
    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 ?
    Like
  • Hello, you can use openRecord or popupRecord. Find more info: http://manual.ninoxdb.de/en/function-and-language-reference/
    Best regards, Alex
    Like
    • Jmorang
    • Jmorang
    • 6 yrs ago
    • Reported - view
    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?
    Like
  • 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
    Like
    • Lebertre
    • Lebertre
    • 6 yrs ago
    • Reported - view
    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?
    Like
  • Hello Lebertre,
    you can use layout elements such as headings to insert consistent text for all records. More feature are planned.
    Best regards, Alex
    Like
    • Ewegh
    • Ewegh
    • 5 yrs ago
    • Reported - view
    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
    Like
  • 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
    Like
  • I have the same request - for multiple choice fields. Thank you.
    Like
  • 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
    Like
  • 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.
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    Hallo,
    verwenden Sie folgende Funktion:

    yearquater('Datumsfeld')

    Gruß
    Birger - Ninox Support
    Like
  • 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
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    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
    Like
    • tomek
    • tomek
    • 5 yrs ago
    • Reported - view
    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.
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    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
    Like
    • tomek
    • tomek
    • 5 yrs ago
    • Reported - view
    Thanks :)
    Like
  • Hello,
    How to add a carriage return by programming in a multi-line field?
    Thanks
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    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 "".
    Like
  • 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
    Like
    • Birger H
    • Birger_H
    • 5 yrs ago
    • Reported - view
    –––
    let myTexte := "Robert Jones,

    thanks for your mail."
    myFieldTextMultiLine = myTexte
    –––

    Just enter a CR into a string.
    Birger - Ninox Support
    Like
  • waouuu
    thanks very much
    nice support
    best regards
    robert
    Like
    • ggberg
    • ggberg
    • 5 yrs ago
    • Reported - view
    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!
    Like
Like Follow
  • 4 yrs agoLast active
  • 90Replies
  • 30117Views