Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

1,793
248
2

Joined: 06 Feb 2020

My Posts

Latest Posts

Re: Matching Phone Area Codes to Region
Dave Irving said: Bulk editing has worked to some degree. However, I'm finding that some area codes are auto-populating the fields. It's so weird. The two common ones are (785) and (620).…
- Fred
- yesterday
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
Dave Irving said: Now, I have never used the console before, so how do I convert this over to be used in the console for a one time deal to get the fields updated? I guess you can use the console,…
- Fred
- yesterday
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
On a side note, if you are using MacOS or iOS, you can download the app and then you can download copies of your DB. I think that is a very weird limitation of the starter level that you can't…
- Fred
- yesterday
- 1
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
Dave Irving said: Anyway, it can do the formula once, and permanently fill in another field to save on resources? Ninox can do that. If we take your previous example of Region.…
- Fred
- yesterday
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
Dave Irving said: yeah, like I said. The region and timezone fields only gets updated if it's a brand new record and I'm adding the phone number for the first time. I am on their shared cloud.…
- Fred
- yesterday
- Get help
- Reported - view
Re: como eliminar registro duplicado en mi base de dato
¿Puede ser un poco más específico con los nombres de los campos, los nombres de las tablas? Can you be a bit more specific with field names, table names?…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
can you post a sample of your DB?
- Fred
- 2 days ago
- Get help
- Reported - view
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
- 3 days 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
- 3 days 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
- 3 days 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
- 4 days 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
- 5 days 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
- 8 days 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
- 8 days 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
- 11 days 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
- 11 days 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 wk 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 wk 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 wk 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 wk 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 wk 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 wk 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 wk 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 wk 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 wk ago
- Get help
- Reported - view

1 2 3 4 5 72

Back to top

Ninox-Documentation

Overview

View all topics