Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Fonts, Colors and Borders
Oops, didn't notice the date of the post. Thanks.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Fonts, Colors and Borders
Can you upload it here? It won't get deleted by anyone. :)
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Select multiple rows from en embedded table
You have two choices here: 1) you can create another Contacts reference field, yes you can have multiple links to the same table. Then you can select a second Contact record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Count number of records that fulfil a search criterium
I'm having a hard time figuring out how the two tables will be related. It seems like there will need to be a third table that somehow links the two. For example,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for transfer record N:1
I'm looking at your DB and I don't know what you want done. You have two records in Control_Table and 1 record in Emisiones. Do you want to link the two records to the 1 record?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button for create a new record which has a connection to a record
You can check out this post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Get data from unlinked table
In Ninox, if you want to use the default record number then the easiest way is to just use the name of the reference field. You don't need to use Id. If you do want to use the Id field name then it…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sub-Tables - Add existing record
Whenever I've created linked tabled (child or otherwise) they have always shown the two buttons (Add existing record and Create record). I don't use the web version so I don't know if there is…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for transfer record N:1
can you post the code you are working with?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Put comments in the scripts
@Jacques TUR said: #{ The only flaw of this is that now we have no excuse not to comment our code }# Jacques does it again! Now I'm going to have to comment my code.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
It is quite amazing what you can do without being a developer for Ninox and no access to the root code. Thanks for doing all this.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Update Reference field from Text Field
Why do you type in the name of the company into Serviced Customer when you already have it stored in the Customer table? Can't you drop the Serviced Customer field and just use Customer?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Rafael said: I have taken part of your idea, In the Table Deliverables there are Docs with information, text, Date, Week etc, some Docs are issue to cliente in the same week in the Select_Week there…
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Need Help to create a History Control Table
Good start. Thinking it over you have to put the new loop at the very top since you want all of the current code to run for each record in Documentos. It took me awhile to figure it all out so here…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need Help to create a History Control Table
@Rafael said: The scrip you send me works great very useful, but there are options to generate all documents one one click on the button, no one by one ? You would have to use the for loop command.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Explanations and examples of Ninox functions available in our docs
Maybe add the ideas in this post to the manual so more can learn about filtering with arrays without using contains.
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Latest update broke Ninox!??
I did find another bug this time in the editor where in switches it won't auto correct properly. In the old version if you typed: switch field1 do case 1: function code case 2: function code;…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Latest update broke Ninox!??
The Mac App store says for me that v3.7.3 is the latest MacOS version and I am able to duplicate the issue. :(. I guess I didn't have to do this movement yet. The iOS app did not exhibit this issue.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Sean Please don't take my wording to be any where close to what Jacques actually does in his code. I have no idea how the magic happens, so my words are my simpleton's way of trying to understand…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Thanks Jacques! I wondered how it would affect performance as your code must have to go through the entire DB and figure out how every field is related to every other field.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Hours result from appointment field
Thank you for the kind words. I do take into account a "lunch period" with Lines 3 - 10. But if it is consistent 1 hour for you then a simple step2 -1 can also work.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Hours result from appointment field
Looks like you have two date/time fields (Day Start and Day End), so let us work with what you have. You can try something like: let step1 := number('DAY END' - 'DAY START'); let step2 :…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 93 94 95 96 97 137

Welcome to the Ninox community

Fred

My Posts

Re: Array trouble after update

Re: The Formula don't work. For Approval view

Re: Script for transfer record N:1

Re: Fonts, Colors and Borders

Re: Fonts, Colors and Borders

Re: Select multiple rows from en embedded table

Re: Count number of records that fulfil a search criterium

Re: Script for transfer record N:1

Re: Button for create a new record which has a connection to a record

Re: Get data from unlinked table

Re: Sub-Tables - Add existing record

Re: Script for transfer record N:1

Re: Put comments in the scripts

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Update Reference field from Text Field

Re: Track selection of Dynamic Multiple Choice field

Re: Need Help to create a History Control Table

Re: Need Help to create a History Control Table

Re: Explanations and examples of Ninox functions available in our docs

Re: Latest update broke Ninox!??

Re: Latest update broke Ninox!??

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Hours result from appointment field

Re: Hours result from appointment field

Overview