Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: Issue with the 'select ... where...' function
In a separate formula field does the following work? count('Equipe impliquee') Can you post a sample copy of your DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox API issue
@Care said: Now, my question is why I've the table ID itself appended to the ID ? current output is ``` ['LB13213'] ``` That is the default Ninox response to a select.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Link multiple records to a parent record
Sounds like you have some programming experience so take a look at this post for some ideas. Sounds like you want to use a dynamic multiple choice field and a button.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue with the 'select ... where...' function
From the looks of your table, you can also remove the select statement as well: let directeurices := count('Equipe impliquee'['Type de fonction' = 1]) You use the relationship link in lines 3 and 5,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create new incremental record within a selection
Can you give more background to your DB? Table names? Field type/names? How do you want these license plates incremented? Button? Trigger? How do you want to handle deletion of records?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
@Rick Castellini said: Why is there not a way to easily combine these two??? You just need to follow my comments from earlier replies. If you are in Trade Details table then you can create the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic value formula for choice field
One thing to check: that the word(s) are spelled exactly. You have “Guests” and “guests” in your post. Another DB thing is to make sure you tell Ninox to look for text and not the choice number.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
@Rick Castellini said: The "Trade Date" in my Trade Details table (and in the "Income by Day" view I'm trying to create) is the "opening date" of a NEW trade.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
From your picture, the 'Trade Date' is 04/01/2023 in the top right side of the image. I don't know what 'Trade Date' you are showing in the table view on the left side of the image.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
Oops, I misread the initial image. Just change the 'Close or Roll Data' to match your field name 'Closed-Roll Data'.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need transfer only the Approved.
@Rafael said: but does not transfer anything. Did you check to make sure there are records that match the requirements? You can put this in a formula field:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
Why did you add the select command in there? We are using the reference link to get your data. With more info here is what it should look like: let t := this;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need transfer only the Approved.
My guess would be editing line 5: for i in (select 'Batch Documents' where text(Statusfield) = "Approved") order by 'Name Document:' do
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Subscription and payment ER example
The forums are an informal help group so you can post a sample of your DB and a description of what you want done and we can do our best to help you. If you are under time constraints then maybe it…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Transfer all info on table to another table (script don't work)
@Rafael When you get a chance, please explain what you did so others can learn from this post.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Transfer all info on table to another table (script don't work)
The loop part is working fine. There are three records in the 'Bach Documents' table and it creates three records in the 'wbs by Documents table. Ninox is naming all the new records the same name as…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
To filter reference links you would use the double brackets [ ]. If we use your pics from the original post then I guess it would look something like: let t := this;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Transfer all info on table to another table (script don't work)
is one of the if statement returning the wrong answer? or is the for loop part not working?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog
Welcome to Ninox. You have encountered the first big design point when developing a DB. How to control data entry. May I introduce you the concept of “Dashboards”.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
I can't make a comment on pivot tables, but to get values from your child table is easy. At the parent level, you can create a formula field, we can call it 'Total Roll Premium', with:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Count item per Week
@Rafael add another crtn between display and totalString? I'm not sure what you want to do with "most right", but if you want finer control of the text then you probably have to look into using html.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Remove comma from dmc-print layout
It looks like you are trying to use dynamic fields in a way that it is was not probably designed to do. The dynamic value name looks like it only controls the display of the records within the Ninox…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
@Dave Irving I've done that myself. Many times. How do you think I knew to ask you about it. Sleep well.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
@Dave Irving I don't think Ninox can do magic and make up records. :) Are you sure you are showing all records in your table? Can you post a sample of your DB? It would be easier to troubleshoot.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Remove comma from dmc-print layout
can you post your code? or You can look at this post for some ideas.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 64 65 66 67 68 137

Welcome to the Ninox community

Fred

My Posts

Re: Issue with the 'select ... where...' function

Re: Ninox API issue

Re: Link multiple records to a parent record

Re: Issue with the 'select ... where...' function

Re: Create new incremental record within a selection

Re: Trying to find a solution (pivot view??)

Re: Dynamic value formula for choice field

Re: Trying to find a solution (pivot view??)

Re: Trying to find a solution (pivot view??)

Re: Trying to find a solution (pivot view??)

Re: Need transfer only the Approved.

Re: Trying to find a solution (pivot view??)

Re: Need transfer only the Approved.

Re: Subscription and payment ER example

Re: Transfer all info on table to another table (script don't work)

Re: Transfer all info on table to another table (script don't work)

Re: Trying to find a solution (pivot view??)

Re: Transfer all info on table to another table (script don't work)

Re: Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog

Re: Trying to find a solution (pivot view??)

Re: Formula to Count item per Week

Re: Remove comma from dmc-print layout

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

Re: Remove comma from dmc-print layout

Overview