Fred

San Francisco, USA

3424
540
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Trying to "hide" records in main table
Just wondering, did you create the same field and field names in the Received table? The second post code doesn't work cause you have a semicolon after newReceived thus ending the line.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
Hi Hardy - A button is a "layout element". If you go to Edit Fields you will see on the right side Add layout element. From there you can add a button. When you double click on the button field you…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
There is no "Move" command so you will have to hard code the copying of data field by field from the Orders table to the Received table. There will also be many steps to get to your desired results…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Query
Do you want this 3rd table to be a "dashboard" that you can use view info from other tables? You can view this video for the basics on how to create a dashboard: https://www.youtube.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
Hi John - Going off the data in your picture, 1 day would be the appropriate result for the days command as there are 3 records with Type = Call and the earliest date is 17/01/2022 and the latest…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Query
Are you talking about creating a third table? or adding a view element to an existing table? If the field Nr is a reference field in User to Contractor,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
That helps a lot. So let us start small. If we want to find all records where field Type = 1 (or "Calls") in the History table then figure out how many days elapsed between the earliest date and the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to set a value for a switch elements
Hi Heidi - Can you be a bit more specific? Since a switch is based on the value in a field and if the field is NOT a formula field you can put something like this in the formula section of a button:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
You will need to use the days functions. days(datefield1, datefield2)
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Script: Test for 'if this is true and that is true, then..."
your logic is correct, to extend the search you just add "and". Can you post the exact code you are using and why it is not working?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Retrieving a deleted record made by mistake
Only if you made a backup of the DB.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Spam spam spam span spam egg and chips
Hi Mel - I use to send an email everytime there was spam then I got my hand slapped by their Support team for doing that. And the forums are just the same as they are.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trouble with two table references - same settings, different results.
Oh, Davie. You have now experienced another pain point for Ninox users, the Manual or lack of one.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Spam spam spam span spam egg and chips
Sadly Ninox has shown that it doesn't really care. Many of us have complained. Many have gotten responses that they are working on it. And years later we have a new generation of users experiencing…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
"but if an application was to look at a string and see Letter, Letter, Number, Number could it not decide to treat two numbers as a single number and sort acordingly?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
The question of do you need a separate task table will depend on the data being kept. Are you doing the same task to every photo? Could you be adding more tasks in the future?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Print View Problem - Select record if
Hi Anna - Just a few questions: I could be wrong, it looks like Journey is a field in another related table to Shipping, what is that table name? What is the name of the reference field that links…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
You have text in your formula so I don't see how Ninox can treat it otherwise. Excel does the same thing. I have a formula that puts together a series of numbers that look like normal numbers, i.e.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
You can view your pages from either the Folder table or the Pages table. You said, "I want a database to help my workflow, checking off tasks as they are done." That is a good use of a database.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
You are running into the issue of how Ninox sorts text vs. numbers. Your formula is considered text by Ninox so it sorts all the 1's then 2's. To fix this you need to add a zero in front of single…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem with syntax and filling array
Re-reading your post it looks like Customers is a reference field in whatever table you are in. Which means you don't need to do a select statement to get data from the Voornaam field if you want to…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem with syntax and filling array
You are very close to getting Ninox. You wrote: (select Customers).Namen.Voornaam like Customers.Namen.Id = 4 It could be written: (select Customers where Namen.Id = 4).Namen.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: I cannot edit a database in Ninox Mac app
Hi Philippe - The Mac app version is not really a multi user/device database creation tool. The app version allows one device to be the owner of the DB and thus the only device that can edit.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: simple Payment receipt table setup
Which template did you end up using? I ask so I can take a look at it. Which table are looking at to see what you got paid on a particular day?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: simple Payment receipt table setup
Have you looked that the invoice or accounting DB template that is built into Ninox? When you create a new DB you can select either template.
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 117 118 119 120 121 137

Welcome to the Ninox community

Fred

My Posts

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Query

Re: How to count days

Re: Query

Re: How to count days

Re: How to set a value for a switch elements

Re: How to count days

Re: Script: Test for 'if this is true and that is true, then..."

Re: Retrieving a deleted record made by mistake

Re: Spam spam spam span spam egg and chips

Re: Trouble with two table references - same settings, different results.

Re: Spam spam spam span spam egg and chips

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Advice wanted for database design (modelling?)

Re: Print View Problem - Select record if

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Advice wanted for database design (modelling?)

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Problem with syntax and filling array

Re: Problem with syntax and filling array

Re: I cannot edit a database in Ninox Mac app

Re: simple Payment receipt table setup

Re: simple Payment receipt table setup

Overview