Skip to main content

Ninox-Documentation

Paul Chappell

Paul_Chappell

87
19
0

Joined: Thu Apr 14 07:54:39 UTC 2022

My Posts

Latest Posts

Re: Updating calculation - effect on existing records
@Davie Not really. You would have to ensure an Appointment date cannot be changed. Which is not a problem, but what if someone enters the wrong date to begin with? You would need to handle that.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Updating calculation - effect on existing records
Yes. Values like VAT are only correct at a particular point in time when they are used. Once used they don’t change, even if the future VAT value changes. If that makes sense. Tax is another example.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Updating calculation - effect on existing records
I would have a 'Settings' table with a 'Pence Per Mile' field, and another 'Pence Per Mile' field in your 'Main' table. When a new record is created in the 'Main' table read the current Settings.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: How do I change the date format to year.month.day?
@Fred That's brilliant. Never knew you could do that!
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How do I change the date format to year.month.day?
Something like this: let tempDate := today(); let newDate:=year(tempDate) + "/" + format(month(tempDate), "00") + "/" + format(day(tempDate), "00")
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Image size in fx field
@John Try using an html() command with style attributes:
- Paul_Chappell
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view

1 2 3 4

Back to top

Ninox-Documentation

Overview

View all topics