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 Renzo, open the map, find an address –> then tap on the needle. Now you can save the location. Best regards, Alex -
Yes, ok thank you so much Alex. Ciao
-
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. -
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.
-
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! -
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 -
hi. thank you for your answer. i decided to use another approach which works for me
. -
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? -
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 -
hi Alex,
Thank you, i maild you the information
Jurgen -
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 -
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 -
Hi Ivan,
Ninox doesn't support multiple chocie fields, yet. But that's planned.
Best regards
Frank -
Hi Ivan,
we'll add this with the next release.
Regards
Frank -
is it possible, to pass over an address to the map search field? -
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 -
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 -
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 -
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 -
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) -
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 -
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? -
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
-
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 -
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