Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Formula Problem.
Right, so you would change it to: let t := this; if 'Horas Ganada Real' = 0 then 0 else sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales') end
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Design Table for WBS
Hi Rafael - You are not wasting my time. Try this in Level 3: a.'Level-2' = b.mainCategory And this in Level 4: a.'Level-3' = b.'Level-3' Like I said earlier, you have too many "a"s and "b"s.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formula Problem.
One way is: let t := this; if 'Horas Ganada Real' = 0 then 'Horas Actuales' := 0 else sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales') end
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Design Table for WBS
What are the formulas you are using?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: if, then not working within a function field script.
One solution is to check for null instead of length of text. You can try something like: if 'Business Process 1' != null then (select 'Business Process Defs' where Id = theIDb).…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to use Date, Start time and time interval Field
@Admin said: My solution was the following: let dS := Date + 'Finish Time'; let dF := Date + 'Start Time'; 'Massage Booking' := appointment(dS, dF) For some reason dS was putting the time as the…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Auto-populate a predetermined Number in a field depending on a choice made in a combo-box
You need a 3rd table to track the choices selected from the different multiple choice fields. Can you let us know what your DB structure looks like, i.e.…
Fred
Fred
2 yrs ago
Get help
Reported - view
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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 yrs ago
Get help
Reported - view
Re: In Forms, search for string only returns one record
Can u share your code?
Fred
Fred
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 yrs ago
Get help
Reported - view
1
112
113
114
115
116
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
