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
3614
570
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Design Table for WBS
@Rafael Sanchis You had too many "a" and "b" in your code. Try deleting the contraints and just use the selection of the fields in the left side of the window.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Auto-populate a predetermined Number in a field depending on a choice made in a combo-box
Are you part of the Ninox Webinar EN 2022 cloud team? If not then email support@ninox.com and ask to be added. Then look at Cascading DC Fields DB for some great work by @RoSoft_Steven Rooryck .…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: How to use Date, Start time and time interval Field
Take a look at this post for a possible solution: https://forum.ninox.com/t/x2hbm58
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Auto-populate a predetermined Number in a field depending on a choice made in a combo-box
Hi Steve So you have a multi-choice field with 3 choices. Make another formula field and put this in the formula: number(multichoicefieldname) As you make your choice you will see different numbers…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Now that I've had a chance to play around more, I've modified: Avances Disciplinas Documentos FechaCorte Take a look to see what you can do when you have a horasconsumidas table tracking horas.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Design Table for WBS
@Rafael Sanchis said: Horas Ganadas Real are the Earned value it reflects the amount of hours that has actually been accomplished to data date. I read this as Horas Ganadas Real should be a formula…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
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
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
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
Fred
3 yrs ago
Get help
Reported - view
Re: In Forms, search for string only returns one record
Can u share your code?
Fred
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Fred
3 yrs ago
Get help
Reported - view
1
120
121
122
123
124
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