Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3616
571
5

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

My Posts

Latest Posts

Re: Mirror tables in different databases
There are two ways to update tables in different DBs. 1) If you have a private cloud instance then Ninox has built in tools to talk between DBs. I am so hoping this comes out in Public cloud.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Printing a VIEW ? This is how it can be done:
It is weird. I tried it on another DB and it took over 2min before the PDF popped up. I tried it in your DB and the PDF showed up within seconds. My main DB does not create the PDF at all.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Printing a VIEW ? This is how it can be done:
@RoSoft_Steven do you find it easier to use custom JSON then just the Ninox field names? One one table, I'm just trying to get a simple field: {d.CurrentTeamName} and when I click on print nothing…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Reset line id to 1 with new invoice
This numbering is very simplistic. If you ever delete any records this method does not track the deleted number so you could have skip numbering, or you could have duplicates (if the last record was…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Reset line id to 1 with new invoice
bink inkel said: 3 Tables: HOME where I enter the date, INVOICE, where i enter customer info, and LINE ITEMS. That is an interesting idea. So you would enter in a record in HOME that would store the…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Reset line id to 1 with new invoice
How do you create your line items? From Invoice? From a dashboard?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
You can take advantage of the power of relationships by changing your code to: let a := this; let s := sum(Earnings[Payday = a.Paydate].'Total Net'); let v := sum(Tracking[Payday = a.Paydate].…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
It took a bit for me to find the picture. It is in the Contractors table not the Earnings table. Also Paydate is a date field not a formula field. So I modified the code in Payment field to: let a :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
@Shawna said: The picture shows the Earnings Table. So you have a view element called Earnings in the table called Earnings? @Shawna said: Paydate is a formula field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Run a fórmula under two conditions
@Rafael If it is just for you then you don't have to switch just remember that you can't select more than 1 milestone.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Run a fórmula under two conditions
So are you saying the following code doesn't work? if Real1 != null and Milestones = 1 then (first((select Milestones where Id = 1).MLT) * Hours) / 100 end Maybe put numbers() around Milestones so…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
The picture in your original post is from which table? Is Paydate a date field? What kind of field is Payday in the other tables? I don't think John is saying your formula doesn't work.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Admin Column Filters overriding individual user filters. Can I prevent this?
Sadly you can't set filters of columns in table view to be browser based. That is why you should consider setting up Pages, as fields can be set with Binding:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Thoughts on a DB redesign

Hi all - So I've been developing my team show jumping DB the last few years quite organically. I knew almost nothing about setting up a DB when I started and had zero knowledge of DB coding.…
- Fred
- 1 yr ago
- 23replies
- 386
- Learn and share
Re: Ninext project
@Jacques TUR We all wish other software developers were as responsive. Thanks, Jacques, for making Ninext an indispensable toolkit.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR I tested it out in a copy of the Ninext db you have posted and it works fine copy/paste from a table to a Page. But copy/paste doesn't work if I have a dashboard with no table view.…
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Ninext project
Hi@Jacques TUR - What is the code without looking for a local table, that we put in the Trigger after open? I'm trying to create a test DB you can access.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Ninext project
Jacques TURI tried the copy/paste from table to Page and I can't get it to work. See attached video. Screen Recording 2023-10-09 at 9.11.36 AM Am I missing something?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Remind me where my data is stored
to be safe, you could export a Ninox file of your DB so you know where the files are. Then when you reinstall the app you can reimport the files.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: v3.10 No Usage Overview
@Fabio Well, I feel dumb. Thanks.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
v3.10 No Usage Overview

Hi everyone - I have the basic cloud plan (which means I'm on v3.10) and now I don't have access to Usage Overview. I can't see how much space I'm using.…
- Fred
- 1 yr ago
- 7replies
- 112
- Learn and share
Re: Ver 3.10 - new PAGES Feature
@Sotirios Zormpas I'm transitioning one of my dashboards and it is a lot of work. Maybe once Jacques fixes Ninext's copy/paste to work in Pages then it will be easier.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Convert total time not in days but only in hours
I guess I answered the question. If you convert your time data into decimals then you can use the column sum function and you will get what you want.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Convert total time not in days but only in hours
ERKENS ChristopheIf that is what I think it is, a table form column function, then I think the answer is No. You can't change how Ninox does sum of columns.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum Based on Choice
@danlap333 When you get a chance, please mark the post answered.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 62 63 64 65 66 145

Back to top

Overview

View all topics