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 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 -
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 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 -
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