Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3831
posts
614
likes received
5
followers
Badges
Latest Posts
Re: Need a Constrain
The sample you sent does not have the WBS_5 table. Can you upload another one?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: seeing it..just i don't really understand what i need catalogue for The catalog is a way of tracking what is available to customers. It might fit better with a more durable product…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: where is the returned field more background: The Products table is where you have a record for each item you could make in a day. the Catalog table is where you create a daily…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
did you see the file i uploaded to a post earlier? download the file then import the DB.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
I'm sorry, I didn't give a little direction. The Quick View table is a dashboard, that is incorrectly setup. When you open the table, click on the first record.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: how to project this db
@Alan Cooke It could be. My thought was that the Order table and its subtable, Order Items, just tracks the product shipped to and returned from a specific customer on a specific day.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea there already is a field for returned.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: imagine there are 10 records. 8 are sell and 2 return. Even if i put a 0 value in the sell field of this 2 record, the report will count 10 record, like 10 selll..…
Attachment
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: coding needed for certain field?
it is not an easy task but it is not impossible. it is vital to learn if you want to make your DB a true database an not just a glorified spreadsheet.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea the way I was thinking about it that you would eventually fill in a number for returned even if it is 0. you can have the field default to 0,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: a subtable of this table where i select the product and quantity..with a radio button to change between sold/returned I see it as two different fields (sold/returned) in the order…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: coding needed for certain field?
I understand how you feel. I was really lost the first time I wrote my first Ninox code. I have never written code before, so it was all new to me. Sadly there is no one place that I learned.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to project this db
off the top of head, I would suggest: 1) a catalog table that tracks your daily production of your items. this would mean there would be a subtable, i.e.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Subtraction result with minus
One is a number field (2) and one is a formula field (1), so I’m guessing 2 is actually smaller than 1. The formula in 3 rounds so it comes out to negative 0. But that is just a guess.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is there "Click to Accept" Functionality
I've never worked with an OnPrem version so I'm not sure what it can do or not. Will your customers be accessing your DB directly? or will you use a front end then send the data to your DB?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is there "Click to Accept" Functionality
You will have to create your own buttons.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Invite people
There seems to be some server work going on as I keep getting connection lost messages.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Fields reference table
@Sam Remember in Ninox you create the reference field from the many table back to the 1 table.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Dynamic Choice Fields reference table
@Sam said: yes they are fields in the table. There are 100 number records. There are 12 colors. When I add a new color it gets positioned in number 101.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Dynamic Choice Fields reference table
I am confused by what you mean by @Sam said: The last number row of the 'Color' Column is 12. If Color and Number are fields in the same table there will always be the same number of records in the…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Problem here
@Rafael said: 1 - The Issue Week is 1N Issues Week to Control Issues. If you need to create a new record in Issues Week every time the button is pressed in Documents then you need to start your code…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Problem here
Sorry for the delayed response, I'm fixing up our bathroom so I was grouting the tub today. What is the purpose of the Issues Week table? Are you creating new records or just linking any new records…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Fields reference table
@Sam said: The last number row of the 'Color' Column is 12. When I enter a new color it is placed in row 101. I’m not sure what you are telling us here. Is ‘Color’ a field in ‘Dynamic Field Data’?
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: New functions
with such a major change to contains() and index() it is surprising that Ninox didn’t officially mention it. thanks Jacques for exposing the inner workings of Ninox.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Reverse Order by
@netSME_Sylvain Moesching Thanks for the update. I was trying to find your account in this forum but nothing came up with just your name.
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
1
89
90
91
92
93
154
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
