Skip to main content
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
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3411
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: how to project this db
Can you make it work with just a month field like in my code? Since you have a dynamic choice field, getting data from it is not as straight forward as a simple choice field.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: definitely there is somehting not working in your db you are correct. I didn’t take into account the year field in the formulas. I was thinking I would use the year,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: the problem is that i don't know how to write the code for this reporting... Did you take a look at the Quick View table in my sample? It has an example of how to do it.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need a Constrain
@Rafael one way is to create a yes/no field, and put a formula that checks for true/false in the writable section of the fields you want to control.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need a Constrain
@Rafael said: The Constrain in Level 5 is : a.'Level-4' = b.'Level 4' not work. Double check that you have the correct field in the b section. There is no 'Level 4' field in the WBS_5 table.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need a Constrain
The sample you sent does not have the WBS_5 table. Can you upload another one?
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea there already is a field for returned.
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: Is there "Click to Accept" Functionality
You will have to create your own buttons.
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Learn and share
Reported - view
1
72
73
74
75
76
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
