Nick

Greece

Joined: Wed Jan 01 00:00:00 UTC 2014

My Posts

Latest Posts

Re: Moving DB from mac desktop to ninox cloud acct
Hi, export your db from Mac app using the "Save Archive As" option and then import the archive to Ninox web app.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
Sorry I meant Steven (not steven)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Could someone explain to me please how to use the Trigger after open?
Another option (really useful to me) is to open a specific table and view upon opening like this: --- if getPlatform() = 3 thenopenTable("Journal", "iPhone")elseif getPlatform() = 4…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: how to import an excel sheet
You need to assign a match field (record id or something else) with the option "Only new records".
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Text im Druck nach Bedingung in Zeile anzeigen
'Name Firma' + "" + Abteilung + "" + if 'zu Händen von:' = null then'Strasse, Hausnummer' + "" + Postleitzahl + " " + Ortelse'zu Händen von:' + "" + 'Strasse,…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Anniversaries in Calendar view
When I needed something similar, I made a new date field with options - Show in calendar = yes - Show as = Title - Anniversary = yes Then with the Update multiple records option I copied to the new…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: faster refresh
I'm afraid this is not possible, yet :-( I have this problem too...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to automatically create multiple records from a button?
Yes there is. For this example, create a number field e.g. 'Nr of records' (how many records will be created). Use this code for a button placed to Master table.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Limit number of records in a subtable
Another approach, button for table Suscripciones: --- let t := this;let c := cnt(select ´Planes Suscritos´ where Relationship_Name = t);if c = 0 thenlet n := (create ´Planes Suscritos´);n.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Can I format my time to "number"
If I understand you correctly... Υou have 2 fields, one with a time format of 10:45 and a calculation field of 10.75.Use only one (the desired) field in the print form.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Can I format my time to "number"
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Technical Help/Create new record in child table
Reference_Field field is the name of the relationship between 'CEOs of Airlines' and Airlines table.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: How to copy a row or just few collummns from one table to another using a button
With this code (button in Inventory List table) you can copy records to another table. ---let variable1 := Inventory_Field1;let variable2 := Inventory_Field2;let variable3 := Inventory_Field3;let c :…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: I have a table in a database that is hidden, how do I un-hide it?
Go to Edit Fields screen and uncheck the Hidden checkbox...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Technical Help/Create new record in child table
'Airlines' table -> Trigger on Create --- let t := this;let c := (create 'CEOs of Airlines');c.(Reference_Field := t)end ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Adding colour to records
Create a formula field and try this code: --- styled(text(YourField), if YourField like "1-A" then"red"elseif Text2 like "2-B" then"blue"elseif Text2 like "3-C" then "yellow" endendend, "") ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Can I format my time to "number"
This gives you the above results: number(TimeField) / 3600000
- Nick
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: All Records Suddenly Disappeared
Apparently you applied a filter by mistake and your records are hidden.Just remove the filter...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: I can't find the printer icon.
As far as I know printing to pdf is not supported on Android, yet.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Mac application freezes
Screenshot from Mac app info... Ninox v. 2.6.7
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Great experience
LOL
- Nick
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Mac application freezes
@Cal I'm on the same setup and Ninox Mac app runs fine.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic progressive number WHEN IMPORTING - Urgent help!
Hi SoluMaker, I never tried something like that, maybe someone more experienced will give us his lights.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: 2 views different fields
@Marc, I apologize for the incorrect answer, I saw the title of the topic and did not read the post in detail :-(
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic progressive number WHEN IMPORTING - Urgent help!
Yo can update the ID Numbers after the import with something like this (button or Console) let myNum := 1;for i in (select YourTable) order by FieldName doi.…
- Nick
- 4 yrs ago
- Get help
- Reported - view

1 9 10 11 12 13 28

Welcome to the Ninox community

Nick

My Posts

Re: Moving DB from mac desktop to ninox cloud acct

Re: Could someone explain to me please how to use the Trigger after open?

Re: Could someone explain to me please how to use the Trigger after open?

Re: how to import an excel sheet

Re: Text im Druck nach Bedingung in Zeile anzeigen

Re: Anniversaries in Calendar view

Re: faster refresh

Re: Is there a way to automatically create multiple records from a button?

Re: Limit number of records in a subtable

Re: Can I format my time to "number"

Re: Can I format my time to "number"

Re: Technical Help/Create new record in child table

Re: How to copy a row or just few collummns from one table to another using a button

Re: I have a table in a database that is hidden, how do I un-hide it?

Re: Technical Help/Create new record in child table

Re: Adding colour to records

Re: Can I format my time to "number"

Re: All Records Suddenly Disappeared

Re: I can't find the printer icon.

Re: Mac application freezes

Re: Great experience

Re: Mac application freezes

Re: Automatic progressive number WHEN IMPORTING - Urgent help!

Re: 2 views different fields

Re: Automatic progressive number WHEN IMPORTING - Urgent help!

Overview