Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Set auto completion on Ninox editor
I came across an interesting issue. If I type "F" then "l" (lower case L) before Jacques code kicks in, it automagically fills in the floor command. This doesn't happen with any other command.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Design Table for WBS
@Rafael Sanchis said: I have 3 kind of hours The hours plan, each hours is related with FechasPlan and Milestones, what the document need earned at the DataDate The Hours Real,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Design Table for WBS
if you start tracking horas in ganadasReal then you can 1) create a new formula field in the Disciplinas table: sum(Actividades.Documentos.GanadasReal.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: In Forms, search for string only returns one record
Can u share your code?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Save trial database work to my recently purchased Local Mac Ninox environment.
@Andreas There should be a little arrow in the top right corner of your DB, select Download Archive. Then in your Mac App click on Import Archive.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR YES! I love number 3! It always annoyed me that I have to keep clicking around after selecting field names the old Ninox way. Very thankful that you are spending your time doing this.
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Save trial database work to my recently purchased Local Mac Ninox environment.
@Andreas Did you save your DB as an archive from the cloud then import the archive on your Mac?
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view

1 128 129 130 131 132 153

Welcome to the Ninox community

Fred

Re: Set auto completion on Ninox editor

Re: Design Table for WBS

Re: Design Table for WBS

Re: In Forms, search for string only returns one record

Re: Save trial database work to my recently purchased Local Mac Ninox environment.

Re: Set auto completion on Ninox editor

Re: Save trial database work to my recently purchased Local Mac Ninox environment.

Re: Design Table for WBS

Re: Set auto completion on Ninox editor

Re: Design Table for WBS

Re: Are there Trigger limitations?

Re: Copy text for subtable and paste in textfield in main table

Re: Set auto completion on Ninox editor

Re: Button to open related record in a related table

Re: Copy text for subtable and paste in textfield in main table

Re: Set auto completion on Ninox editor

Re: Set auto completion on Ninox editor

Re: Design Table for WBS

Re: Button to open related record in a related table

Re: Short Contributors Bio

Re: Design Table for WBS

Re: Linking one record to one record

Re: Design Table for WBS

Re: Design Table for WBS

Re: Design Table for WBS

Overview