Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Using a Dynamic Choice and filter for records.
I saw the attempts made during the Ninox support webinar. Have you tried something like: let t := this; select 'PROJECT EQUIPMENT' where 'room-ID' = t.'room-ID'
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Calc Dynamic problems
I'll start with the 2nd question first: @Rafael said: Now is for one year there are possible a script for works on weeks for years. One way to do it would be to add a new formula field in Cost_Week…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam said: I did the substitution and it resulted in One invoice for the Appointment with all the lines from both owners. Instead of 2 invoices with One owners per invoice. Oops, sorry.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
How do you want to use ApptID in Invoices? There isn't a field called ApptID in Invoices. Do you want to copy ApptID in Lines to Invoice Number in Invoices?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam said: You will also see that there is no longer an appointment table. That is why I am hoping to RE-Create the invoices. Each appointment ID should have the corresponding number of invoices = to…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
@arisziniatis there isn't anything free that I know that speaks directly to your situation. You can watch the following videos, in English, for background on relationships and many to many…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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

1 85 86 87 88 89 154

Welcome to the Ninox community

Fred

Re: Using a Dynamic Choice and filter for records.

Re: Calc Dynamic problems

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Get count of chosen values from different table

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

Overview