Fred

San Francisco, USA

3616
572
5

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

My Posts

Latest Posts

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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Ninox tutorials stopped working?
@Randy dunno what to say.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox tutorials stopped working?
They seem to be working now:
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox tutorials stopped working?
which website?
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: double click in a cell puzzle.
When I double click, in the MacOS app or browser, the record quickly pops out but disappears just as quickly. I don't have any issues with it not allowing me to edit inline.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
I found that moving in this direction would just move the load onto the other tables and make those tables slow to respond. So I've moved away from this and now use use the record() command to get…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Total of the selected option
This line: cnt((select Albums)[myObject]) doesn't make sense. Why are you doing a select again? The variable myObject is the result of your filter so you only need that variable in the cnt() command.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Auto-populate pricing from another table?
What you need is a reference field in Project Details that points to Job Pricing. You can call it whatever you want in Project Details, but let us leave it as Job Pricing for now.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Updating related fields
@John Wilmans said: I have tried to have a way (using the inventory form) where a hostess can go in and use a bottle of wine on the charter and then update the table from that form.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Updating related fields
I would like to be able to add the drinks etc to their table so I can keep a record of: their charter, which boat they were on and what they ate and drank. This can be done.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson said: - Create some kind of price table in Ninox. I don’t bill per hour, instead per job. So I’m imagining a list of jobs varying in price/mapping to the client type,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Count of records in joined table
You must have a N:N (many to many) table linking Event Details with Staff, what is the name of that table? That N:N table should show up in your staff table so you can do a count of the reference…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING
Welcome to Ninox. As@simon said, you probably don't need another table since Radio Net Operators. Like you said, the two tables would have a 1:1 relationship which makes me wonder why create a…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 65 66 67 68 69 145

Welcome to the Ninox community

Fred

My Posts

Re: Select Where Function - Please Help!

Re: V Lookup between 2 tables

Re: Auto-populate Music Library Fields

Re: Ninox tutorials stopped working?

Re: Ninox tutorials stopped working?

Re: Ninox tutorials stopped working?

Re: Help me LOOP please.

Re: Select Where Function - Please Help!

Re: Auto-populate Music Library Fields

Re: Auto-populate Music Library Fields

Re: Help me LOOP please.

Re: Auto-populate Music Library Fields

Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.

Re: Is it possible to add a custom RTF field in Ninox (like TinyMCE)?

Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.

Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.

Re: double click in a cell puzzle.

Re: Pass current viewing record Id to a view element column formula

Re: Total of the selected option

Re: Auto-populate pricing from another table?

Re: Updating related fields

Re: Updating related fields

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Count of records in joined table

Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING

Overview