How to enable Javascript

Latest Posts

Re: Where is Working Phase Lookup???? I've always use a variable when using the create command. I think it helps Ninox keep track of the new record better. I've seen people not use in other formulas,…
- Fred
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Reference to items in the same table Take a look at this post. It even has a sample DB you can see what is going on.
- Fred
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Reference to items in the same table Just a reminder that dynamic choice fields have a 100 item limit.
- Fred
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Latest update broke Ninox!?? @james said: On the Mac App Store, Ninox is now at 3.7.6. Has anyone updated to this version? Is it still buggy? So far so good for me. They fixed Jason's issue and sorta of fixed mine.…
- Fred
- Fred
- 4 days ago
- Get help
- Reported - view
Re: Where is Working Phase Lookup???? @Mauro Schiappelli said: In the new created record the Field WorkingPhase is null. But newWorkPhase contains value!!! That was my first question. If you put: let currentRow := this; let newPhase:…
- Fred
- Fred
- 5 days ago
- Get help
- Reported - view
Re: Newbie Formula Question Welcome to the world of DB. What is the reference field name that links your two tables together? Can you post a picture of your data model?
- Fred
- Fred
- 8 days ago
- 1
- Get help
- Reported - view
Re: Time calculation problem after the update if you create two more formula fields and put: number(Time1) in one and number(Time4) in another you will see that they are not the same time. Time1 is exactly 3,600,000 and Time4 is 3,646,313.…
- Fred
- Fred
- 9 days ago
- Get help
- Reported - view
Re: Choice field: There can be only one! One possible solution is to put this in the Trigger after update of the Status field: let t := this; if Status then for loop1 in (select child)[toTable2 = t.toTable2 and Id != t] do loop1.…
- Fred
- Fred
- 9 days ago
- Get help
- Reported - view
Re: Enforcing Referential Integrity You can always change Composition to "No" then when you delete a record in the old Parent it won't delete the child.
- Fred
- Fred
- 10 days ago
- Learn & Share
- Reported - view
Re: Enforcing Referential Integrity Ninox already does what you are wondering. You can always build a test DB and try it out.
- Fred
- Fred
- 10 days ago
- Learn & Share
- Reported - view
Re: Choice based on field content Take a look at the substring function to find out what is in the 5th position of the text field. Do you need help with setting the choice field?
- Fred
- Fred
- 10 days ago
- Get help
- Reported - view
Re: Button for create a new record which has a connection to a record I can try. You have a good start with: create TableName The issue you are encountering is you have not specified the record to link to the new record in TableName.…
- Fred
- Fred
- 11 days ago
- 1
- Get help
- Reported - view
Re: Ninox DB viewed in a Wordpress Website Hi Carlos - If you want to provide interactive function (allow them to select their name and pull up specific data on just them) on your site then you will need to use a third party service like…
- Fred
- Fred
- 11 days ago
- 1
- Get help
- Reported - view
Re: Formula needed: Here is one solution: let t := this; let x := first((select AVANCES_PROYECTO)[Semana = t.Semana - 1]); 'Horas Ganadas Real' - x.'Horas Ganadas Real' It will give you a blank for the first record and…
- Fred
- Fred
- 11 days ago
- 1
- Get help
- Reported - view
Re: Formula needed: Would you like me to post a possible solution or would you like my help in figuring out a solution?
- Fred
- Fred
- 11 days ago
- Get help
- Reported - view
Re: Formula needed: Can you post the code that you have written so far?
- Fred
- Fred
- 11 days ago
- Get help
- Reported - view
Re: Trying to get a Max numeric calculated value Steven is correct. Ninox either 1) allow the code to go through since there is no error message or 2) shouldn't allow it and error out. bad form on Ninox's part.
- Fred
- Fred
- 12 days ago
- 1
- Get help
- Reported - view
Re: Can I use a "sum" function to add up just the items found through a search? I actually didn't answer your question. To take your formula: sum((select collections).value_av) and to then filter it you can add the following sum((select collections)['title or name' like "Rex the…
- Fred
- Fred
- 12 days ago
- Get help
- Reported - view
Re: Trying to copy Date and Date + Time to new Field You can do some regex in Ninox. But it is always better to have clean data to start with.
- Fred
- Fred
- 12 days ago
- 1
- Get help
- Reported - view
Re: Can I use a "sum" function to add up just the items found through a search? You have two options: 1) You can use the table form (all) in your collections table. You can display the field value_av. Then you can sum the value_av column.…
- Fred
- Fred
- 12 days ago
- Get help
- Reported - view
Re: Ninext loading modules not requested I posted this on Friday but I didn’t realize that I lost the ability to post for the whole weekend, this post was held up for moderation. After I posted I saw that you posted your new info.…
- Fred
- Fred
- 12 days ago
- Get help
- Reported - view
Ninext loading modules not requested
Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…
- Fred
- Fred
- 2 wk ago
- 2replies
- 24
- Get help
Re: Array trouble after update I'm currently running 3.7.3 as well and I haven't noticed anything so far and I uses arrays in my formula everywhere in my main DB. What I don't do is use the array function,…
- Fred
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: The Formula don't work. For Approval view You wrote the same if statements: if 'Rev 0' != null and if 'Rev 0' is not null are the same thing.
- Fred
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Script for transfer record N:1 let tx := Deliverable first(select 'Control_Table' [Deliverable = tx]) There is no 'Deliverable' field in Emisiones, so this code won't work.
- Fred
- Fred
- 2 wk ago
- Get help
- Reported - view

1 2 3 4 5 44 Next

Fred

Fred

San Francisco, USA

1,093
124
2

Joined: 06 Feb 2020

Follow