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
Plugins
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
3901
posts
630
likes received
5
followers
Badges
Latest Posts
Re: Design Table for WBS
@Rafael Sanchis said: I send you again the DB, I create a new table avances with the 8 weeks the field % Acumulado Plan I take now manually from Table Documentos, Form Avances,…
Attachment
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Set auto completion on Ninox editor
Just want to let MacOS app users know that you can use the short code on the front page of Jacques' gitHub page. I took out the close record feature if not in admin mode because I can image myself…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Design Table for WBS
Hi Rafael Ok, well it looks to me (maybe someone else who is following along can come up with a better solution), that you don't track enough data to be able to figure out work done by week.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Are there Trigger limitations?
Is Välj Land a choice, multi choice or dynamic version of the two? what you are seeing is just the numerical code assigned to the choice.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Copy text for subtable and paste in textfield in main table
Can you check that there is a record in CP that is related to the record in Treatment? In the picture, sorry for the all the extra fields, you see that I'm in Table1 and Table2 is linked because you…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Set auto completion on Ninox editor
Thanks Jacques, I got it working. Yes, first I needed to change the Keyboard shortcut for Input Source to something other than ctrl+space. I first tried it at the default table view then went to…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Button to open related record in a related table
If 1 patient has only 1 image and 1 interview then you can, at least, put an image field in the patient table. Depending on how big the interview table is you can also put all the field into the…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Copy text for subtable and paste in textfield in main table
Hi there - Is there a reason why you need to copy data from CP to Treatment? Since CP is a child of Treatment there is no need to copy data, you can just show the data from CP that is related to…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Set auto completion on Ninox editor
What a fast response! I've copied the "new" completion.html into a formula field and still nothing happens. In another formula field when I type "select r" then press ctrl+space.…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Set auto completion on Ninox editor
Hi Jacques - I'm using the Mac app and I can't seem to get it to work. I'm copying the code into a html() function and when I press ctrl + space nothing happens.…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Design Table for WBS
@Rafael Sanchis give me a few days as I'm pretty busy right now.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Button to open related record in a related table
Hi there - Did you create the reference table field to Patient Data from Image and Interview? It looks like you created a reference field field in Patient to Image and Interview.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Short Contributors Bio
It is nice that a bot brought this thread back up for us. I dabbled with FM back in v5. I am not a coder or have any formal DB training. I started with Ninox to create a sport league DB and have…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Design Table for WBS
Hi Rafael - I am unsure where we are right now. Generally, when moving from Excel (a flat spreadsheet) to a relational database it is good to try to forget how Excel does it and allow your mind to…
Fred
Fred
4 yrs ago
Get help
Reported - view
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
4 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
4 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
4 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
4 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
4 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
4 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
4 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
4 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
4 yrs ago
Get help
Reported - view
Re: The New IPhone Display Mode
@RoSoft_Steven Rooryck thanks.
Fred
Fred
4 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
4 yrs ago
Learn and share
Reported - view
1
132
133
134
135
136
157
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
