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
    • donnydave
    • donnydave
    • 4 yrs ago
    • Reported - view
    Hi,
    Thanks, I found it.
    Like
    • kbolt12
    • kbolt12
    • 4 yrs ago
    • Reported - view
    What are *New UI elements for free text" introduced in v2.3.4?
    Like
    • Birger H
    • Birger_H
    • 4 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
    Like
    • kbolt12
    • kbolt12
    • 4 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
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Its not the data field type "multiline" - its the layout element "Free text". Have a look.
    Like
    • kbolt12
    • kbolt12
    • 4 yrs ago
    • Reported - view
    Silly me. Thanks
    Like
    • kbolt12
    • kbolt12
    • 4 yrs ago
    • Reported - view
    Date Fields: Can the date format be changed, for example to display DD/MM/YYYY ?
    Like
    • Birger H
    • Birger_H
    • 4 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
    Like
    • john
    • john
    • 4 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!
    Like
  • 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
    Like
    • john
    • john
    • 4 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?
    Like
  • 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
    Like
    • john
    • john
    • 4 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.
    Like
    • Jred
    • Jred
    • 4 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.
    Like
    • kustra
    • kustra
    • 4 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!

    Like
Like Follow
  • 4 yrs agoLast active
  • 90Replies
  • 30102Views