Fred's Profile | Ninox community

Badges

Latest Posts

Re: Help with Formulas please!
Have you tried a formula field? If all the names you listed are field names in your table then the new formula field should work.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Format numbers when printing
Sorry, change the [] to () and it should work.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac not responding
A new version (v3.5) is out with the following enhancements: Smart cachingImproves the consequent loading time of table views and execution of select queries and Transactional scripts A new construct…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac not responding
@JJ, I too agree. I was peeved that I had to redesign everything because of the limitation that doesn't have a hard number to go by. @John, as usual, you have figured out that I had to put a formula…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Format numbers when printing
If your pressure field is a formula field then put this in: round([formula],2)
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: add field by script
Hi Peter - It could look something like this: let i := 'Chosen ID'; let p := first(select Parent where Id = i); let ch := (create Children); ch.Parent :…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: add field by script
I don't see anything wrong with the code. Maybe the trigger is not kicking off like you think? Which table/field trigger did you put the code in? Can you put the code in a button then see if it works?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac not responding
I've encountered those issues before. For me it was because I had too many select statements in my db. I have a sports league db, so you can image stats are a big function of any sports league.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Using sub-tables
HI DH - A linked table is not necessarily a "sub" table. If you didn't set Composition to Yes on the sub table then it is not a sub. The tables are now just linked.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
My guess, since I don't have a db to try this one. Is that in the counter situation, you are not telling the for statement to use a specific email address.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Date functions & calculations
So it just dawned on me that the yearly code will not help you out as it will always compute a date a year from now. What you need for yearly payments, is a month and day you need to make the yearly…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Date functions & calculations
Hi zenmom - Sadly, there is no way to edit posts. Just post your corrections/additions. Here is one option. See if this is what you want: 1) I created a choice field and called it PaymentSchedule.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Hi Mel - 1) what happened to the recipient variable? if you changed it to sendemails then you need to replace all instances of recipient. 2) in the "to" section,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do I copy some certain fields when creating an invoice?
Hi Art - They say pictures are worth a thousand words. Unfortunately in database work that does not hold true. Can you post your button code so we can see what is going on.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Replicating a value in a different field via a button
Hi Giovanni - I don't think you can do last-1. Wouldn't that be awesome. How many subrecordsN do you have to go back? Is it a static number or does it grow as your DB grows? If it is static,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Try: let myCount := if cnt(sendmails) > 75 then 75 else cnt(sendmails) end; <--you need an end to close the if statement.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Auto numbering based on specific conditions
Just thinking that you can put this in the Trigger after update for the Grupa field so whenever you select the Grupa it will create an ID for the record.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Auto numbering based on specific conditions
Hi Marija - One issue I see is that you are mixing text and numbers in your ID code so it will make things a bit harder to increase number by any amount without having to do more coding.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to add this?
What do you mean by a separate folder?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Changing the Inventory template
Those are good points. If you have 100s of the same item then you would have to create 100's of records, thus making the article table combersome. If you do want to track serial number per item,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Changing the Inventory template
Of course Steven is correct that you don't need a new table. I would think that serial number is a characteristic of guitar, so I would create a serial number field in that table.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to refer to the current Table
If the tables are not related then: let x := select ThisTable; If the tables are related: let x := ThisTable;
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Global script to merge records of multiple tables
If we are talking about tables in the same database, then wouldn't your suggestion also have the same security issues? I use the app version so I'm not very familiar with permissions.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Global script to merge records of multiple tables
If the "Corporate Table" is a way for people to view data then may I suggest the use of Dashboards. Basicaly a dashboard is a empty table that is linked to other tables so you can do summaries or…
- Fred
- 4 yrs ago
- Get help
- Reported - view
UTC Date Time issue

Hi all - I just got a PurpleAir indoor sensor and now I want to create a DB that stores all of the data. The issue I have right now is that all the date/time I download from the company is text that…
- Fred
- 4 yrs ago
- 229
- Get help

1 141 142 143 144 145 157

Welcome to the Ninox community

Fred

Re: Help with Formulas please!

Re: Format numbers when printing

Re: Ninox for Mac not responding

Re: Ninox for Mac not responding

Re: Format numbers when printing

Re: add field by script

Re: add field by script

Re: Ninox for Mac not responding

Re: Using sub-tables

Re: emailing list of contacts not changing the firstname in list

Re: Date functions & calculations

Re: Date functions & calculations

Re: emailing list of contacts not changing the firstname in list

Re: How do I copy some certain fields when creating an invoice?

Re: Replicating a value in a different field via a button

Re: emailing list of contacts not changing the firstname in list

Re: Auto numbering based on specific conditions

Re: Auto numbering based on specific conditions

Re: Is there a way to add this?

Re: Changing the Inventory template

Re: Changing the Inventory template

Re: How to refer to the current Table

Re: Global script to merge records of multiple tables

Re: Global script to merge records of multiple tables

UTC Date Time issue

Overview