Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: Calc Dynamic problems
@Rafael To help others, what was your solution?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calc Dynamic problems
You are telling the dynamic multiple choice (dMC) field 'Choice Weeks' to look upon itself (it is in the table Actual Cost & Hours and trying to do a select of the same table.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calc Dynamic problems
@Rafael said: But in the formula not appear the I1. And work perfect. Yes, "I1" is an internal reference for Ninox. How can it "work perfect" and give an error? If you got rid of line 2,…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 68 69 70 71 72 137

Welcome to the Ninox community

Fred

My Posts

Re: Calc Dynamic problems

Re: Calc Dynamic problems

Re: Calc Dynamic problems

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

Overview