Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
1,793
248
2
Joined: 06 Feb 2020
Follow
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
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
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
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
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
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
Fred
2 days ago
Get help
Reported - view
Re: Matching Phone Area Codes to Region
can you post a sample of your DB?
Fred
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Fred
2 wk ago
Get help
Reported - view
1
2
3
4
5
72
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics