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

90 replies

null
    • Alexander_Koenig
    • 9 yrs ago
    • Reported - view
    Hi Renzo, open the map, find an address –> then tap on the needle. Now you can save the location. Best regards, Alex
    • renzotiberi
    • 9 yrs ago
    • Reported - view
    Yes, ok thank you so much Alex. Ciao
    • peru1_ordinaryorg
    • 8 yrs ago
    • Reported - view
    Is it possible to change the background color of a "Yes/No" field? I would like to be able to see "No" with a red background and "Yes" with a green background. I looked and I can't see a way to do it.
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hi, there is a workaround: You can change the color of choice fields instead. Add the values "Yes" and "No" to a choice field and pick the color.
    • info
    • 8 yrs ago
    • Reported - view
    Hi,
    i am looking for a more flexible way of 'anniversary'.
    i need to set a schedule that repeats after: 1 week, 2 weeks, 1 month, 2 months or 3 months based on a start date, to be repeated until an end -date and an interval (choice-field).

    each date should show up in the agenda

    any idea/suggestion?

    much appreciated!
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hi, thanks for your request. What kind of table do you have? Date entries will be shown in the calender. If you have questions, you can also write to support@ninoxdb.de.
    Best regards, Alex
    • info
    • 8 yrs ago
    • Reported - view
    hi. thank you for your answer. i decided to use another approach which works for me
    .
    • info
    • 8 yrs ago
    • Reported - view
    Another challenge i am facing.
    i created a database that stores information about domainnames:
    what is their renewal date, who is the registrar, price etc.

    the field renewal-date is set to show in the caledar & anniversary

    so far so good.
    it appears that all dates in December do not show in the calendar.
    any idea?
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hi jurgenvt,

    thanks for your request. We will try to recreate the issue. Could you provide us more information? Which Ninox Version are you using, which operating system.
    It would be helpful, as well, if you could send us a screenshot or the template to support@ninoxdb.de

    Best regards and thanks, Alex
    • info
    • 8 yrs ago
    • Reported - view
    hi Alex,

    Thank you, i maild you the information

    Jurgen
    • iii_iolcz
    • 8 yrs ago
    • Reported - view
    Hello Alexander,
    is it possible to move needle in the map? Sometimes the place has no address or address is not exactly the place.
    Thanks,
    Ivan
    • iii_iolcz
    • 8 yrs ago
    • Reported - view
    Hi Alexander,
    allows a field type "choice" to choose several options instead only one?
    Yes, I can replace it by several yes/no fields, but it is not so elegant :-)
    Thanks,
    Ivan
    • Frank_Bohmer
    • 8 yrs ago
    • Reported - view
    Hi Ivan,
    Ninox doesn't support multiple chocie fields, yet. But that's planned.
    Best regards
    Frank
    • Frank_Bohmer
    • 8 yrs ago
    • Reported - view
    Hi Ivan,
    we'll add this with the next release.
    Regards
    Frank
    • Chris_CH
    • 8 yrs ago
    • Reported - view
    is it possible, to pass over an address to the map search field?
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hi Chris, not yet. The Address needs to be selected from within the map by clicking on the needle. We have more features for the location field to be added already on the change request list. But cannot say exactly when we implement it.
    Kind regards, Alex
    • Yves
    • 8 yrs ago
    • Reported - view
    Hi,
    Is it possible to create unique indexes? I want the combination of 2 columns of a table (name - surname) to be unique.

    Thanks,
    Yves
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hi Yves,
    there is no way to prevent users to enter any kind of data. As a workaround you can use a formula to detect duplicates:
    let X := name;
    let Y := surname;
    cnt((select Tabelle where name = X and surname=Y))

    Let me know if this helps. You can also drop a line to support@ninoxdb.de
    Best regards, Alex
    • Lebertre
    • 8 yrs ago
    • Reported - view
    Hello,

    I use a form to get inscriptions on a register and I would like to use the "button" field as a form validation and skip automatically to the next record (ready to fill) for the next people. (as a click on the +)
    What formula can be used for this behavior?
    Thanks
    • jonfusa
    • 8 yrs ago
    • Reported - view
    So, I need a work around to capture duplicated entries before the record is added.
    The scenario: we have a inventory table which has a field for the inventory ID.
    The issue: when we add additional inventory using the same inventory ID ,we create a second record instead of " flagging" and informing the user " this ID is already present " in the table.
    Any solutions or ideas are greatly appreciated. In my olden days MS Access referred to this as a field parameter set to (non-duplicated)
    • Alexander_Koenig
    • 8 yrs ago
    • Reported - view
    Hello,
    use this formula on the button:
    create table_name
    table_name is the name of your table. You find more info in the NX language reference.
    Best regards, Alex
    • jonfusa
    • 8 yrs ago
    • Reported - view
    I tried this command on button and can't seem to make it work.
    i have a table PACID with a related table ModuleID.
    So I added a button to the PACID and place in the button formula create ModuleID but nothing happens when I touch the button.What am I missing?
    • jonfusa
    • 8 yrs ago
    • Reported - view
    Oppps, so it is creating a new record in the ModuleID table it's just not opening the form as if I pressed the + button in the little circle to add a record to the ModuleID table from the PacID form
    • Leonid_Semik
    • 8 yrs ago
    • Reported - view
    Hello jonfusa,
    please try the formula

    let P := Nr;
    let A := (create ModuleID);
    A.(PACID := P);
    (let NN := number(A.Nr);
    popupRecord(record(ModuleID,NN)))

    regards
    Leo
    • jonfusa
    • 8 yrs ago
    • Reported - view
    Hi Leo,
    Thank you for the response, here is the code that Birger Hansen emailed me which is working
    let thisid := _id;
    let m := (create ModuleID);
    m.(PacID := thisid);
    popupRecord(m._id)

    I really wish I could figure out the logic in this code
    • Leonid_Semik
    • 8 yrs agoThu, November 10, 2016 at 7:18 AM UTC
    • Reported - view
    Hi,
    sorry, in the german version are _id to Nr.

    Leo
    • jonfusa
    • 8 yrs agoThu, November 10, 2016 at 10:40 PM UTC
    • 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
    • Lebertre
    • 8 yrs agoSun, November 13, 2016 at 1:29 PM UTC
    • 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 ?
    • Alexander_Koenig
    • 8 yrs agoMon, November 14, 2016 at 8:46 AM UTC
    • Reported - view
    Hello, you can use openRecord or popupRecord. Find more info: http://manual.ninoxdb.de/en/function-and-language-reference/
    Best regards, Alex
    • Jmorang
    • 8 yrs agoTue, November 15, 2016 at 9:33 PM UTC
    • 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?
    • Alexander_Koenig
    • 8 yrs agoWed, November 16, 2016 at 2:39 PM UTC
    • Reported - view
    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
    • Lebertre
    • 8 yrs agoSun, November 20, 2016 at 3:06 PM UTC
    • 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?
    • Alexander_Koenig
    • 8 yrs agoSun, November 20, 2016 at 3:34 PM UTC
    • Reported - view
    Hello Lebertre,
    you can use layout elements such as headings to insert consistent text for all records. More feature are planned.
    Best regards, Alex
    • Ewegh
    • 8 yrs agoTue, January 10, 2017 at 9:44 AM UTC
    • 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
    • Alexander_Koenig
    • 8 yrs agoTue, January 10, 2017 at 2:48 PM UTC
    • Reported - view
    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
    • ajtsmith_edacuk
    • 8 yrs agoWed, January 18, 2017 at 2:52 PM UTC
    • Reported - view
    I have the same request - for multiple choice fields. Thank you.
    • Alexander_Koenig
    • 7 yrs agoFri, January 20, 2017 at 2:55 PM UTC
    • Reported - view
    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
    • Bastian_Vorholt
    • 7 yrs agoTue, March 7, 2017 at 8:18 AM UTC
    • Reported - view
    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.
    • Birger_H
    • 7 yrs agoTue, March 7, 2017 at 9:51 AM UTC
    • Reported - view
    Hallo,
    verwenden Sie folgende Funktion:

    yearquater('Datumsfeld')

    Gruß
    Birger - Ninox Support
    • fermestursin
    • 7 yrs agoSun, April 23, 2017 at 9:35 AM UTC
    • Reported - view
    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
    • Birger_H
    • 7 yrs agoMon, April 24, 2017 at 9:31 AM UTC
    • 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
    • tomek
    • 7 yrs agoWed, April 26, 2017 at 9:11 AM UTC
    • 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.
    • Birger_H
    • 7 yrs agoWed, April 26, 2017 at 12:24 PM UTC
    • 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
    • tomek
    • 7 yrs agoSun, April 30, 2017 at 3:06 PM UTC
    • Reported - view
    Thanks :)
    • CISOFT_Sarl
    • 7 yrs agoSun, May 7, 2017 at 3:52 PM UTC
    • Reported - view
    Hello,
    How to add a carriage return by programming in a multi-line field?
    Thanks
    • Birger_H
    • 7 yrs agoMon, May 8, 2017 at 11:37 AM UTC
    • 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 "".
    • CISOFT_Sarl
    • 7 yrs agoWed, May 10, 2017 at 10:24 AM UTC
    • Reported - view
    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
    • Birger_H
    • 7 yrs agoWed, May 10, 2017 at 10:32 AM UTC
    • Reported - view
    –––
    let myTexte := "Robert Jones,

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

    Just enter a CR into a string.
    Birger - Ninox Support
    • CISOFT_Sarl
    • 7 yrs agoWed, May 10, 2017 at 11:29 AM UTC
    • Reported - view
    waouuu
    thanks very much
    nice support
    best regards
    robert
    • ggberg
    • 7 yrs agoSat, June 17, 2017 at 1:37 PM UTC
    • 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!
      • donnydave
      • 7 yrs ago
      • Reported - view
      Hi,
      Thanks, I found it.
      • kbolt12
      • 7 yrs ago
      • Reported - view
      What are *New UI elements for free text" introduced in v2.3.4?
      • Birger_H
      • 7 yrs ago
      • Reported - view
      Its the "Free text" element. This is the first in a series of additional layout elements to be introduced in the next updates.

      Birger - Ninox Support
      • kbolt12
      • 7 yrs ago
      • Reported - view
      Ah, the "Multiline" element. I couldn't remember if it was there previously. However, it's no different to the previous Text field which could be "stretched" to allow multi line. Or is there something I'm missing?

      By the way, the minimum length can be more than the maximum length
      • Birger_H
      • 7 yrs ago
      • Reported - view
      Its not the data field type "multiline" - its the layout element "Free text". Have a look.
      • kbolt12
      • 7 yrs ago
      • Reported - view
      Silly me. Thanks
      • kbolt12
      • 7 yrs ago
      • Reported - view
      Date Fields: Can the date format be changed, for example to display DD/MM/YYYY ?
      • Birger_H
      • 7 yrs ago
      • Reported - view
      You can do this:
      –––
      format ( 'My Date field', "DD/MM/YYYY" )
      –––

      ...or you can change the global settings of your device. Ninox will always use the system preferences.

      Birger - Ninox Support
      • john
      • 6 yrs ago
      • Reported - view
      I have set up a database, with data imported from another very old database. Two of the fields were originally created from their equivalent of "Choice" fields, and are now imported as text. I would like them to continue to be Choice fields, so how do I go about converting the Ninox text fields into Choice fields? Or other workaround!
      • Sakshi_Singh
      • 6 yrs ago
      • Reported - view
      Hi John,

      You can create a "Choice" field in Ninox with the desired choices that you want to populate. Next, you can update the "Choice" field through mass data update from the "Update multiple records.." option from top centre settings menu. The mass data update operations lets you update field by assigning calculated value.

      Regards,
      Sakshi- Ninox Support
      • john
      • 6 yrs ago
      • Reported - view
      OK, partly done that - but now how do I word the calculation so that it copies the content of the original text field?
      • Sakshi_Singh
      • 6 yrs ago
      • Reported - view
      Hi John,

      Request you to write a mail to us at support@ninoxdb.de, sharing your requirement and we should be able to find a solution.

      Regards,
      Sakshi- Ninox Sipport
      • john
      • 6 yrs ago
      • Reported - view
      Hi Sakshi
      OK actually, I managed to work out that all I need to do for the calculation is to pop in the name of the source field and nothing else. So that is sorted.
      • Jred
      • 6 yrs ago
      • Reported - view
      Hello,

      Is it possible to use the values of another table as a value list in a choice field?
      An example: I have a contact table with the field "Country" and I want it to be a choice type to be able to select the country name from a list.

      As I see, the only way is to enter and order by hand each of the more than 190 countries.

      Is it like that? Thank you.
      • kustra
      • 6 yrs ago
      • Reported - view

      I have the same question.  I found a spreadsheet of countries on the web and imported this into its own table and created a relation with my contacts table, but the result looks rather cumbersome and inelegant, and does not integrate with the other address fields (which are in a subtable).  Thanks for some ideas!