Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Issue with the 'select ... where...' function
@Stef said: count(select Compagnie.'Équipe impliquée' where 'Type de fonction' = 1) still doesn't work... well because you are mixing up how to write selects with relationship links.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Issue with the 'select ... where...' function
Well I guess we should have been clear about asking what table are you starting in. According to your first post, it showed you were in the Compagnie table.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view

1 80 81 82 83 84 153

Welcome to the Ninox community

Fred

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

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

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.

Overview