Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3400
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Ninox tutorials stopped working?
@Randy So in my Safari (16.6) is works fine. Which means it probably has something do with the ninox cache. I have issues with Ninox's website and have to delete my browser cache every so often.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Select Where Function - Please Help!
@Randy said: The BUT is that I am NOT getting this, but ZERO. Trying to figure out where/how I am going astray? Ok, this is where having the DB is handy.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Auto-populate pricing from another table?
@Taylor Hanson said: Also, I'd love to have the Job Pricing item I select (in this case, Logo Design) auto populate in the 'Details' field above it. I will need to be able to add more text to that…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Select Where Function - Please Help!
@Randy
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Select Where Function - Please Help!
@Randy can you upload a sample DB?
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Select Where Function - Please Help!
@Randy said: select 'Check Ins' where 'Radio Net Date' >= xBeg and 'Radio Net Date' <= xEnd [with no ending ")" ] BUT 'BegDat' Field = Aug 1, 2023 and 'EndDat' Field = Sep 23, 2023.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Auto-populate pricing from another table?
@Taylor Hanson said: However, none of the other 'Job Pricing' items seem to work. Any ideas? You originally had the code written as: if 'Job Pricing N1' = true then 'Unit Price' := 'Job Pricing N1'.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
Sorry, forgot to mention that part.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Select Where Function - Please Help!
Looking at your pictures and your code, it looks like you want data from Check Ins so that is where you should make your select statements (like in your 2nd pic).…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Select Where Function - Please Help!
RandyIn a select statement you just use the table name. select Table1 If you want to filter on a field in a related table (could be a child) then you can add it to after the where then you can add…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: V Lookup between 2 tables
let 'Column 1' := 'Risk List'.'Risk Number'; (select 'Risk List' where 'Risk Number' = string('Column 1')).'Risk Description' Just to clarify, you have a reference field in Reports to Risk List,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
@an_wessel said: I would like to have a field on Table 1 that auto-populates all of the Hymn Titles found in tables 2 and 3 based on Tune Name. So this is what he asked for.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
@Randy dunno what to say.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
They seem to be working now:
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
which website?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Help me LOOP please.
@Vinson Javiero From your posts I think it will help us all if you can copy your DB and put in some nonsense data so we can see what is going on.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Select Where Function - Please Help!
When you do a select command you can only filter at the first table level. I'm guessing, from other posts and your picture, that 'Risk List1' is not a table so you can not do a select on a record.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Auto-populate Music Library Fields
@Mel Charles said: I think that this is because Tune name in Organ Library is a string of words and equally Hymm Titles in Service Book (table b) also has a string of names in that field.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
@Mel Charles Maybe my understanding of the data is wrong but shouldn't the link go the other way between Organ Library and Service Book?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Help me LOOP please.
@Vinson Javiero said: Then Id like to make a report in another table. This table is called "Reports. I have a text fields in the reports table called Column 1, Column 2, Column 3.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
You may want to consider condensing your two Hymnal tables into one. Since they store the same data except for the denomination. So I would recommend merging the two tables then creating a choice…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
@biogendron If you are satisfied with the answers, please mark this post answered when you get a chance.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Is it possible to add a custom RTF field in Ninox (like TinyMCE)?
In a similar vein, I had this one formula field that that is 118 lines long and I kept getting lost with all the if/then and switches, so I looked around and found Sublime text and it helped me keep…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
@biogendron said: I finally got the two field amounts to add together. Only problem now is the field column doesn't show on the main display page. It only can be seen as you are entering the data…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
Is your third field a formula field? If it is then you can do something like: field1name + field2name If it is number field then you can put this in Trigger after update of field2,…
Fred
Fred
1 yr ago
Get help
Reported - view
1
56
57
58
59
60
136
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
