Fred

San Francisco, USA

3527
551
4

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

My Posts

Latest Posts

Re: Unique / Concat giving different results
@Jordine De Guzman can you upload a test DB? so I can see what is going on. It works for me with: concat(unique(Vendite.Article.'Article name')) I start with a view element that does a simple select…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Unique / Concat giving different results
My guess the column is disappearing is because when you use unique() it keeps the data in an array and Ninox can't show data that is in an array in a table column.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
@stef. idea said: I have seen the new view..the code you are suggesting is already there? Yes. @stef. idea said: One question, will be possible if clicking on one row of the subtable will show up…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
One option would be to create a view element in your dashboard and put this for the View formula: let custArticle := gatherData.Vendite.Article; let allArticle := (select '3_Article');…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Indirectly link N:1 records
@Sébastien Guillet Awesome work to figure it out on your own! To help expand your knowledge you can simplify your code by using the power of “this” in line 1.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Parse a specific section of a YouTube URL
@Alan Cooke I too find chatgpt hit or miss. this what I wrote: using regex get all characters after the ? in the following string https://www.youtube.com/watch?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Determine Net New customers via Select Statement for Dashboard
Sorry, I need to stop responding so early in the morning. Forget my last post. You can try: count(select Customers where 'Event Detial' = "") Interestingly,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: link choice
When using dynamic fields you will be using the record() command to get data from the choice in the dynamic field. Try something like: let t := this; let selection := record(Device,number(t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Parse a specific section of a YouTube URL
You can also use extractx: extractx(urlfieldname, "\?(.*)", "i", "$1") Love that chatgpt to point me in the right direction. Or this time it gave me the right code.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula ID count also deleted records
@Walcher Messebau said: My problem is that by inserting the ID formula in a formula field, it also counts the deleted records, while the recordID that Ninox provides does not count them.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Determine Net New customers via Select Statement for Dashboard
1) why do you only want to look at the current month? Don’t you want to check your whole clients table? 2) where are you looking up the client? On a dashboard?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@st oops, you are correct with Line 4. Glad it all worked out.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Breakdown chart by city with filters
You can try this in a new formula field to see if the correct records are returned: let filterStart := 'Début du filtre'; let filterEnd := 'Fin du filtre'; let x :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Trying to automatically link record from one table to open record in another table using a button
If you are linking the current record to 'Tax Tables' then you can try the following: let transId := Id; let transYear := number(year(date)); let taxRec :…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Are you trying to link the current transaction record to a record in Tax Table that has the same Year value? If so then the loop is not needed as there is only 1 record in Tax Table.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@st You don't have a field called Id, so line 4 must be referring to the Ninox record Id. You can't change the Ninox record Id, so line 4 won't do anything.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Limit the number of rows visible in a table view
@Sébastien Guillet try: let filterStart := 'Début du filtre'; let filterEnd := 'Fin du filtre'; let yourSelect := (select Comptes)[date('Première interaction') >= filterStart and date('Première…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula ID count also deleted records
Thanks. I mis-read you post. The row numbers, the far left numbers, are for display purposes only. If you sort your table by another field the row numbers don't change but the record next to it does.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula ID count also deleted records
Can you post the code from your formula field and gives us the names of important fields and tables?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Limit the number of rows visible in a table view
You can take your select and then use the count() and slice() functions. let yourSelect := select.... order by expensesfieldname let cntofSelect := count(yourSelect) slice(yourSelect,cntofSelect-5,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea moving forward it probably be best to start a new post with further questions. I don’t think anyone can follow this in the future.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: how you resize the field? In admin mode, select the field and you see squares on the two short sides of the field. Drag the squares to change field size.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: ..a list of the most returned and most sold take a look now, there is a new View element that points to ‘3_Article’ table and then shows a summary of sold and returned by record.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: one thing..starting from this quick view table...will be able to see it in a grapgic manner..according to the query i do? I don’t think you can do a whole lot with the Quick View,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea ok i copied over the gatherData code from my copy.
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 74 75 76 77 78 142

Welcome to the Ninox community

Fred

My Posts

Re: Unique / Concat giving different results

Re: Unique / Concat giving different results

Re: Help in making queries

Re: Help in making queries

Re: Indirectly link N:1 records

Re: Parse a specific section of a YouTube URL

Re: Determine Net New customers via Select Statement for Dashboard

Re: link choice

Re: Parse a specific section of a YouTube URL

Re: Formula ID count also deleted records

Re: Determine Net New customers via Select Statement for Dashboard

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Breakdown chart by city with filters

Re: Trying to automatically link record from one table to open record in another table using a button

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Limit the number of rows visible in a table view

Re: Formula ID count also deleted records

Re: Formula ID count also deleted records

Re: Limit the number of rows visible in a table view

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Overview