Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

2606
380
2

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

My Posts

Latest Posts

Re: How do I format this field?
That is confusing. Like I said earlier, it looks like a typical formula window, but if you just add the name of the field you want to show then it will just show that field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
Hi MP - go back a page and see Steven's response. Your use of (date field - today) gives you a number counted in miliseconds since Jan 1, 1970. if you use the days(start,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
you have to do a select all before you do a "massive modification of datas". after you typed in "Accepiterus" and clicked Next did it show any records being modified or was the screen blank?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I format this field?
I've never tried putting a formula in a Show As. I just use the field names that I want to show. I can do a concat of field names.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to associate multiple records in one table with a record in another table
In TableB, find the Id of the record you want to link to. If need be show the column. Don't use any personal ID number you may have created. You have to use the Ninox Id for the record Return to…
- Fred
- 3 yrs ago
- Get help
- Accepted
- Reported - view
Re: To replace a letter or a number at the end of a word
ok, to clarify step 2. 2) for iPad user, in table view, click on the rectangle icon with two lines that is next to the Search box then click on Select All
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
if this is just a data correction job then: 1) filter for Elephand 2) right click on a number in the table and click on Select All 3) click on the Gear icon and select update multiple records 4)…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: To replace a letter or a number at the end of a word
Are you going to be replacing the last letter or number with a static letter or number, i.e. everything will end with "X". or will it vary depending on what it finds?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get newly created fields to appear in an existing form? I added fields after the initial setup of a database but I don't see those newly created fields in the form.
Click on any of the column names, then click on Show Columns, then select the field you want to show.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Love the ability to reference a code block in formulas
thanks, I'll give it a look.
- Fred
- 3 yrs ago
- Learn & Share
- Reported - view
Re: How do I format this field?
When you click on Show As it will take you to the Formula editing window. From there you can just select the field name you want to show, i.e. Customer.Name.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Love the ability to reference a code block in formulas

I have a sport league db, so there are lots of stats that use the same block of code. I would love the ability to reference the block of code once so I can make changes to once and it will update…
- Fred
- 3 yrs ago
- 2replies
- 390
- Learn & Share
Re: Price books and ninox
So let us say you have the following tables: Customer Article Pricebook reference field to Customer and Article Sales Order reference field to Article and Customer You want to create a new Sales…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Price books and ninox
if you have the following number fields: price discount <-- data is stored as decimal, so you would type .1 instead of 10 then a formula field called 'final price', or whatever you want to call it,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Populating a field in one table with text value from another table
Hi Stephen - Your thinking would working if there is a relationship between T1 and T2. If there is no reference field in either table linking the two then you just can't say: if T1.Name = T2.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need formula help please.
You probably have a field that tracks total pot (totalPot), so it could be something like: totalPot * Payouts.'1st Place %' or if you have some code that you have tried please post that.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Is there an updated tutorial anywhere that isn't incorrect?
Ninox has hired a new person to work on documentation so we'll see, but yes Ninox is horrible at documentation.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Need formula help please.
what does the data look like in the '1st Place %' field? do you have an example of the code you are trying to use?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox on windows 10
two years since the first post and no Windows app version.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Duplicate fields! Please let us duplicate fields!!!
I guess it didn't make it into v3.3. :(
- Fred
- 3 yrs ago
- Learn & Share
- Reported - view
Re: Creating new link from a N:N relationship
In case anyone is wondering here is the basic code to create a new reference field link from two other reference field links: let xInfo1 := Link1; <--first reference field linklet xInfo2 := Link2;…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Newbie question: Lag or delay in response to clicks/scrolling
Just to double check, are you running the MacOS app and NOT the web version. I too was experiencing really slow responses, most noticebly on my dashboards. I'm running v3.3.1 (got burned on 3.3.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Create Table reference issue with Ninox 3.3.3
sorry, didn't read the your whole subject line. forget what i said. :)
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Create Table reference issue with Ninox 3.3.3
Are you using the MacOS version or web version? If you are using the MacOS, make sure you are not using v3.3.0. Very buggy version. Check the app store and update to 3.3.2.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: A text function that does not work…
look at the substr formula. do you have a field called Text? if you don't, then what do you need to put there?
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 99 100 101 102 103 104 105

Back to top

Ninox-Documentation

Overview

View all topics