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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3612
568
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Linking one record to one record
Hi Leonardo - You can create a reference field in your questionnaire and CT tables to the patient table. That will create a link between the tables. You can then either:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Hi Rafael First, is this path a workable solution for you? If it is then that is an issue that would need to be dealt with. So the question is do you need to check each date for week 9?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Can you try something like? sum((select Documentos)[week(FechaR1) = 9].'Horas Ganadas Plan')
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Hi Rafael - Thanks for sending me a copy of your DB. After reviewing it, the issue is still the same as you continue to reference the field Datadate and that field, like you say,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Just a thought: @Rafael Sanchis said: I have a Datadate that I change every friday So the field 'Datadate' changes every friday and all the fields in the picture for week 9 - 15 use the same field.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Of course. Ask away. im not replying directly to your response as now our thread is so hard to follow. If I did.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
@Mel Charles I guess the issue here is who gets to make things "sticky"? If everyone can then nothing becomes "sticky".
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: The New IPhone Display Mode
@John Halls I never used it until just a few weeks ago so I've only seen the new design.
Fred
Fred
3 yrs ago
1
Learn and share
Reported - view
Re: Design Table for WBS
@Rafael Sanchis that is something that I had in mind. here is a quick mock up of what it could look like. there is no project table since each DB is a project.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: The New IPhone Display Mode
@RoSoft_Steven Rooryck thanks.
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: The New IPhone Display Mode
Hi @Mel Charles How does one do this? I can't find, shocking, any info about it.
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Design Table for WBS
1) it looks like a document can only belong to 1 Gerencia or 1 Area or 1 Sub Area or 1 Subsytem never all at the same time. So you wouldn't even need to have 3 separate fields,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
@Rafael Sanchis I'm not sure what you mean by @Rafael Sanchis said: repeat a lot of same information in the fields for each area, subarea or subsystem.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
@Rafael Sanchis I appreciate that your DB is complicated. It looks like you have spent a good deal of time and effort building it to a place where it is working for you.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
My initial thoughts are that 3 of the 4 WBS tables are not needed as separate tables but as data points for each document. I guess maybe WBS Project could be a table.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
It might be more helpful if you described a particular issue you are trying to solve that got you thinking about the relationships between your tables? @Rafael Sanchis said:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Closing account
1) you need to email support@ninox.com for any account related issues. This is user forum that Ninox support sometimes checks. 2) The on-prem version also requires a windows server so you need to be…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Sounds like your DB is doing what you want. What are you trying to do now that you need help with?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Locking and protecting records in a table
Sounds like you need to create a third table "employee competency" that could be a child of employee. There you would have a reference field to employee and one to competency.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Hi @Rafael Sanchis Are you trying to manage a project or the documents related to a project? Ninox has a Projects DB template that you many want to look at to see if it might be a good start.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Comments Section
Hi @Katie Rayner - Is the comments section a multiline text field?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Repeat Appointments
What do you mean by "repeat appointments? Are you creating a new record that has multiple appointment fields that need to be set upon creation? Are you having to update an existing, or multiple,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Auto populate fields with the value from the previous record?
@Admin Sadly "tomorrow" is not an option. You can do: newRecord.('Order Date' := today()+1
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Put Value Number after Formula
Hi Rafael - Do you have 52 week fields? or Just 9 through 15 that you show in the picture?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Beginner's question
@smarcster Glad you figured it out. I just want to clarify how the mac app version works so you can use it to it full capacity. The app version of Ninox allows you the ability to save your DBs…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
1
121
122
123
124
125
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics