Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Paul Chappell
Paul_Chappell
82
18
0
Joined: Thu Apr 14 07:54:39 UTC 2022
Follow
My Posts
Latest Posts
Re: Make some informations confidential
@John Halls XOR is a great idea. Something I learned about 40 years ago. Well worth investigating how Ninox could handle this.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Make some informations confidential
@Jacques TUR The password will never be stored. It would need to be known by the users and entered manually each time they log in to the database, maybe on a special login form.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Create entry through Calendar?
Yes. Set your Appointment fields to “Show in calendar”. Then double-click or tap a date and time slot in the main Calendar. You are given the choice of creating the relevant appointment.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Make some informations confidential
@Jacques TUR Actually, I have another thought. It would be possible to create 2 functions to encrypt and decrypt a text field based on a password. You would need 3 fields.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Make some informations confidential
@Jacques TUR It is certainly possible to hide sensitive fields in a different hidden table record and protect them by various measures, such as needing a user password.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Make some informations confidential
Not really. As the administrator, by definition, you can always override any sort of security measures. You can use the “Allowed to read” setting for a field to only show the field based on a users…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Disable "copy" button?
Yes. Disable anything. Lots of options. Choose any or all of these. Put them in a hidden formula on any table form. This is just a few of the possibilities.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: How do you manage money from one year to the next?
@Fred @Edward The simplest solution is Fred’s. But on the basis that potentially a customer may ask for extras or there may be added costs, I might just have a table linked to each job (which in…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: sum((select......... with two values
Did you try: sum((select Line).Plan_Earned_Act_E) + sum((select Line).Plan_Earned_Act_P)
Paul Chappell
Paul_Chappell
1 yr ago
1
Get help
Reported - view
Re: Image size in fx field
@John Thanks John. Of course, the other issue with storing large images in a DB is it increases the size of the database. Sometimes this is unavoidable but probably not needed in your case.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Auto create record on first day of the new year
@Michael Have you tried creating a formula field for just the month of the invoice? month(InvoiceDate) will return 1 to 12. Then group the chart by this field.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Image size in fx field
@John Try using an html() command with style attributes:
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Image size in fx field
@John Give it a try. Take a photo. Upload it. And resize.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Image size in fx field
@John unfortunately that’s not the way images work. You can’t just take a large screenshot. You need a large resolution original and then it will automatically shrink/resize to the area of your…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Auto create record on first day of the new year
Why use a Summary table at all? Having 12 monthly and 4 quarterly formula fields in a single Summary record for each year could cause a speed issue presuming you have quite a lot of invoices per…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Image size in fx field
The resolution of your original image is probably too small. You need a larger image otherwise even if you could make it fit it would probably appear distorted.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Send reminder SMS
@Cirugia Toracica Use "Trigger after open" in the database Options and create a routine to loop through the appointment records that meet your date criteria.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@John Halls @Bruno Skëndaj We have all done it when creating systems like this. There is a tendency to over-think the problem and to try and ‘build’ a solution rather then using the built-in…
Paul Chappell
Paul_Chappell
1 yr ago
2
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Bruno Skëndaj Don’t think of Income and Expenses as being daily totals and needing separate tables. You only need a single table called something like ‘Transactions’ (or ‘Money Items’).…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
I haven’t yet looked at your DB, but why do you need Income and Expense tables? Your Sales already contain the value of each sale and Purchase presumably contains the cost to buy products.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Bruno Skëndaj Look at the Ninox example database "Inventory". It is very similar to your requirements. You should be able to get some ideas from that.
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Bruno Skëndaj Presumably you have a Stock record for each type of product? So every time you make a Sale you know which product is being sold. So the formula fields are in the Stock record for each…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
In the Stock table why not have three fields. A ‘Stock In’ field that increases every time you buy new stock from the supplier, a formula field that calculates the Stock Sold by counting the…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: When to use "do as server"?
Just a guess but line 1 shows 2 fields. They look like a date/time field and a number (or maybe yes/no) field. In which case you are not resolving either field.…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
Re: Show/Hide One Record
There must be a reason for hiding a particular record - does it have a unique field value in some way that requires it to be hidden? If so why not just have a formula on the View that says something…
Paul Chappell
Paul_Chappell
1 yr ago
Get help
Reported - view
1
2
3
4
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics