Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Paul Chappell

Paul_Chappell

87
19
0

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

My Posts

Latest Posts

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Accidental Kanban Movement on Phones
In my experience phones should only be used to view details and very rarely be allowed to change fields. So the easiest solution is to stop phone users from moving the cards at all,…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Prefill Field when creating new record
As presumably by definition all guests on the same tour have to go on the same date, if your Guests table is linked to the Tours table then you don't need another date.…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: logging user access?
I do something similar to track database record access. It may work for you. I have a hidden table called AccessLog consisting of 5 fields: User Name, User Email, Table, Record Id, and DateAccessed.…
- Paul_Chappell
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: New 3.6 Script Editor
This is so annoying. If I am entering script and type 'Field Name' and then realise I made a mistake and need to change it to text('Field Name') (or number('Field Name'),…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: New 3.6 Script Editor
@Jacques TUR I agree this is the way it should work. By not recognising existing text attached to the cursor the new Ninox version slows down the editing of any existing script and function.
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically create a record when a date expires
@giuseppe Do you want to create a 'Workings' record automatically, or only after a series of actions? If automatically, and Workings is a hidden sub-table then @WILLIAM PORTER suggestion would work…
- Paul_Chappell
- 2 yrs ago
- Get help
- Reported - view
New 3.6 Script Editor

Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…
- Paul_Chappell
- 2 yrs ago
- 7replies
- 532
- 5
- Get help

1 2 3 4

Back to top

Overview

View all topics