Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: Re-Creating invoices from the Line table
@Sam said: I need a new parent Table to go with the sole child table. Being that the fields are all present in the child table I was hoping there is a way to work backwards.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help in making queries
@stef. idea I don't know. Maybe someone else who knows more can chime in.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam said: I would appreciate some suggestions on how I could re-create invoices from a table of lines. are you talking about importing data from a file?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help in making queries
@stef. idea said: the 6 records limit can be changed? yes, just drag the view box bigger.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Help in making queries
@stef. idea said: for the table that don't respond to query, the opverview Does it have sense to keep it there I am thinking when there will be hundreds or thousands of records...…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Unique / Concat giving different results
@Jordine De Guzman said: Could it be that because it's a dynamic Multiple Choice, it's reading a product with "WALNUT" and "LEGS" as one unit, and so it sees a product "WALNUT" and "RACETRACK" as…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: script to find if student enrolled last year
Can you post the code you are working with? Or post a sample DB.
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 69 70 71 72 73 137

Welcome to the Ninox community

Fred

My Posts

Re: Re-Creating invoices from the Line table

Re: Help in making queries

Re: Re-Creating invoices from the Line table

Re: Help in making queries

Re: Help in making queries

Re: Unique / Concat giving different results

Re: script to find if student enrolled last year

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

Overview