Nick

Greece

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

My Posts

Latest Posts

Re: Accounting Tutorial
I've created a small database (with a lot of help from webinars, this forum, other users, support answers, etc) for my personal finance. It uses double entry accounting system. Take a look...…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Autofill due date based on date of interview.
Don't replace anything. Fabio told you what to do: put in trigger after update in the "interview date". *Just the two fields in your table must be: Interview Date and Due Date.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: "Display field only, if:" help
Try something like this: "Display field only, if:" contains(text(chosen(YourField)), "YourValue")
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to Sum up values from a specific field, only if another field value is the same.
Create a formula field: let myNum := 'Receipt # Group';sum((select Inventory where myNum = 'Receipt # Group').'Purhcase Cost')
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to select more than one option from a multiple choice when creating a record from a button?
For popup the correct record: ... NW.(Contratos := LNK);let childId := number(NW.Id);popupRecord(record('Artículos incluidos en el contrato',childId ))
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to add printPdf file on email ?
I bought the Ninox OS X app too since I don't need Ninox cloud (for now at least). Let's hope we will prove wrong...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Créer un enregistrement dans un sous formulaire
Hi, try this (creates a Invoice Line Item) after you change the names: let myID := Id;let NN := (create LineItems);NN.(Invoice := myID);let myRN := number(NN.Id);popupRecord(record(LineItems,myRN))
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to add printPdf file on email ?
No
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Function result from multiple tables
field_A * field_B not "*"
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: If I have the mac app do I have to purchase the ipad app as well?
If you want the iCloud sync, Yes.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Correction: ... I'm looking for a workaround to update the view to the last record in table view.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Sean, I'm looking for a workaround to update the view to the last record. I thought I found a solution, but it's not working. So, ignore my previous post... Sorry!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Update: It doesn't update the view to show the correct record when it runs from "Trigger after Open". The same code works fine (updates the view) when assigned to a button e.g. on a Dashboard table.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Total of a field in all records.
You can create a 'Formula' field with this code: sum((select TableName).YourField) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Question
@ Bill No, there is not such a feature like Filemaker's "Auto-complete using existing values" in Ninox (for now). Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: if this then that
Get the "Paid Hours is not blank" with this code: 'PAID HOURS' != null Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do you Count the number of records within a database from a specific field?
...or let myNum := FieldName;cnt(select TableName where myNum = FieldName) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How do you Count the number of records within a database from a specific field?
Hi, try this cnt(select TableName where FieldName like "80") Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: what language is this written in
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/what-is-the-language-5bb3daa9a9ece4783d4d6b10
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Thanks again!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Exactly! Thank you Sean for writing my text better... Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
OK, I came up with this code: *** if ninoxApp() = "mac" thenopenTable("General Journal", "All")elseif ninoxApp() = "iphone" thenopenTable("General Journal", "Phone")endend;let maxId :…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Trigger After Open

I use this trigger: if ninoxApp() = "iphone"then openTable("TableName", "PhoneView") else if ninoxaApp() = "mac" then openTable("TableName, "MacView") I want when the Table opens to go to last record…
- Nick
- 6 yrs ago
- 11replies
- 5165
- 1
- Get help
Re: Fields Column Width in Forms
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Can I have ninox on two computers
Yes you can.
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 27 28

Welcome to the Ninox community

Nick

My Posts

Re: Accounting Tutorial

Re: Autofill due date based on date of interview.

Re: "Display field only, if:" help

Re: How to Sum up values from a specific field, only if another field value is the same.

Re: How to select more than one option from a multiple choice when creating a record from a button?

Re: How to add printPdf file on email ?

Re: Créer un enregistrement dans un sous formulaire

Re: How to add printPdf file on email ?

Re: Function result from multiple tables

Re: If I have the mac app do I have to purchase the ipad app as well?

Re: Trigger After Open

Re: Trigger After Open

Re: Trigger After Open

Re: Total of a field in all records.

Re: Question

Re: if this then that

Re: How do you Count the number of records within a database from a specific field?

Re: How do you Count the number of records within a database from a specific field?

Re: what language is this written in

Re: Trigger After Open

Re: Trigger After Open

Re: Trigger After Open

Trigger After Open

Re: Fields Column Width in Forms

Re: Can I have ninox on two computers

Overview