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
90 replies
-
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
-
Hi,
sorry, in the german version are _id to Nr.
Leo -
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 -
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 ? -
Hello, you can use openRecord or popupRecord. Find more info: http://manual.ninoxdb.de/en/function-and-language-reference/
Best regards, Alex -
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? -
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 -
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? -
Hello Lebertre,
you can use layout elements such as headings to insert consistent text for all records. More feature are planned.
Best regards, Alex -
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 -
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 -
I have the same request - for multiple choice fields. Thank you.
-
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 -
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. -
Hallo,
verwenden Sie folgende Funktion:
yearquater('Datumsfeld')
Gruß
Birger - Ninox Support -
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 -
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 -
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. -
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 -
Thanks :)
-
Hello,
How to add a carriage return by programming in a multi-line field?
Thanks -
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 "". -
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 -
–––
let myTexte := "Robert Jones,
thanks for your mail."
myFieldTextMultiLine = myTexte
–––
Just enter a CR into a string.
Birger - Ninox Support -
waouuu
thanks very much
nice support
best regards
robert -
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!
-
Hi,
Thanks, I found it. -
What are *New UI elements for free text" introduced in v2.3.4?
-
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 -
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 -
Its not the data field type "multiline" - its the layout element "Free text". Have a look.
-
Silly me. Thanks
-
Date Fields: Can the date format be changed, for example to display DD/MM/YYYY ?
-
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 -
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!
-
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 -
OK, partly done that - but now how do I word the calculation so that it copies the content of the original text field?
-
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 -
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. -
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. -
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!
Content aside
- 6 yrs agoFri, March 30, 2018 at 10:51 AM UTCLast active
- 90Replies
- 30376Views