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 Renzo, open the map, find an address –> then tap on the needle. Now you can save the location. Best regards, Alex
    Like
  • Yes, ok thank you so much Alex. Ciao
    Like
  • 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.
    Like
  • 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.
    Like
    • info
    • info
    • 6 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!
    Like
  • 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
    Like
    • info
    • info
    • 6 yrs ago
    • Reported - view
    hi. thank you for your answer. i decided to use another approach which works for me
    .
    Like
    • info
    • info
    • 6 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?
    Like
  • 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
    Like
    • info
    • info
    • 6 yrs ago
    • Reported - view
    hi Alex,

    Thank you, i maild you the information

    Jurgen
    Like
  • 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
    Like
  • 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
    Like
  • Hi Ivan,
    Ninox doesn't support multiple chocie fields, yet. But that's planned.
    Best regards
    Frank
    Like
  • Hi Ivan,
    we'll add this with the next release.
    Regards
    Frank
    Like
    • Chris_CH
    • Chris_CH
    • 6 yrs ago
    • Reported - view
    is it possible, to pass over an address to the map search field?
    Like
  • 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
    Like
    • Yves
    • Yves
    • 6 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
    Like
  • 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
    Like
    • Lebertre
    • Lebertre
    • 6 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
    Like
    • jonfusa
    • jonfusa
    • 6 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)
    Like
  • 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
    Like
    • jonfusa
    • jonfusa
    • 6 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?
    Like
    • jonfusa
    • jonfusa
    • 6 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
    Like
  • 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
    Like
    • jonfusa
    • jonfusa
    • 6 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
    Like
Like Follow
  • 4 yrs agoLast active
  • 90Replies
  • 30117Views