Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3421
540
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: The New IPhone Display Mode
@RoSoft_Steven Rooryck thanks.
- Fred
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view

1 113 114 115 116 117 137

Back to top

Overview

View all topics