Fred

San Francisco, USA

3525
550
4

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

My Posts

Latest Posts

Re: Get count of chosen values from different table
@arisziniatis said: I will probably have to do that if there is no other way. You can continue to use your method, but what happens when you change people?…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Get count of chosen values from different table
@arisziniatis said: - First table "Timetable" . Every day is a new record. Every record has 20 to 30 choice fields Each choice field is one person. eg "Jim" and all choice fields have the same values…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: BOMs Managment (2) "Production table"
I think this would be a big undertaking for this forum as I can imagine there would need to be structures put in place before you can even think about writing the code to figure it all out.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam said: I've tried to adapt the code you last provided to result in having a separate invoice for each customer within the current Appointment record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Block of Time on Calendar
I don’t use the calendar at all, but from my limited investigation it looks like Ninox adds a calendar event for any record that has a data in a date field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: BOMs Management
It looks like you can put this in a formula field in Articles: sum('Details Nomenclature'.Cout)
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Overlapping Forms - Mac/Ipad/Iphone
That is a weird bug. I’ve had concerns with the MacOS app now that it is free with how well they will support it and with another iCloud bug reported in forums,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: script to find if student enrolled last year
@AlexisO If you have multiple users then you probably use the cloud version, so you can just access it through a browser and try it out without having to update your app.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: script to find if student enrolled last year
@AlexisO The code i’m using needs version 3.8.x to work. Are you planning on updating or do you need me to rework the code?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: script to find if student enrolled last year
Are you using the cloud version? or the app version (MacOS or iPad)? If the app version what version are you on? Just to verify that this formula is in the enrollment table (a child of Saison) that…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
Here is the code for a new button that goes through each record in Line and either creates a new Invoice record and links the two records or links to an already existing record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam said: I'm guessing this will be a one time operation? not positive Well I hope when you get the new Invoice table setup that you will be adding records in Line through the Invoice table and not…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: script to find if student enrolled last year
You can try this in a formula field in your enrolled tabled: let t := this; let allYears := ((select SchoolYear) order by code); let curIndex := index(allYears, t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
@stef. idea At at the table level, you can select the gear icon and select export data and you can export as a csv or excel.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: script to find if student enrolled last year
@AlexisO said: So I can't set up a print view which could list new and previous student numbers , grouped into classes or levels. How do you want to select the year(s) you want to print?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Unique / Concat giving different results
How did you get the text of your dMC to show? I had to add text() around my dMC field. I also couldn't get the column to display in a view element or a table view without a concat() around the unique…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 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

1 73 74 75 76 77 141

Welcome to the Ninox community

Fred

My Posts

Re: Get count of chosen values from different table

Re: Get count of chosen values from different table

Re: BOMs Managment (2) "Production table"

Re: Re-Creating invoices from the Line table

Re: Block of Time on Calendar

Re: BOMs Management

Re: Overlapping Forms - Mac/Ipad/Iphone

Re: script to find if student enrolled last year

Re: script to find if student enrolled last year

Re: script to find if student enrolled last year

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: script to find if student enrolled last year

Re: Help in making queries

Re: script to find if student enrolled last year

Re: Unique / Concat giving different results

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

Overview