Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

Re: Not Displaying Appointments on Mondays???!?!?!?
That is a weird one. I've too tested it on my MacOS app and I can not duplicate the issue. You should probably email support for help with this one.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Small problem with this formula
I'm not sure what table you are starting in. I say this because you say: DataDate := loop1.Date; and I don't know what table the field DataDate is in. Let us walk through your for loop command:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Import csv files with related tables.
From my quick review, there is no way of setting reference field links during the import process. I don't even see the fields as being available. Which means you will have to 1) import the data into…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
@Mike N. said: which is why I asked the question because this is a whole new way of thinking for me. It is a whole new way of thinking for me too. My written description of the process is just as…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
You can try something like this in a formula field: let a := [1, 2, 3]; let b := [2, 4, 5]; let xCntA := a[(var subA := this; count(b[= subA])) > 0]; if cnt(xCntA) = 0 then "True" else "False" end…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
You can do 1 of the following at the very end: step2 or step1[(var r2 := this; count(xTar[= r2])) = 0]; Basically you need to have an array at the end.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Jump
You would use the Contraints part of the LT_Actividades field. You would put this code in: a.DISCIPLINAS = b.LT_Disciplinas
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@Mike N. said: I get lost though on step1 and step2. I'm still learning what is really happening as well. I'm just parroting what I've seen. You can try this post for more background.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Filter a view by Id
If you are in the appointment table then: let t := this; (select AppointmentLine)[Appointment = t] If you are in some other table then you can just adjust the t to include the path to the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: App cloud sync ?s
You are looking at two different DBs. You have to manually copy any changes (structural or data) between the two. They are not linked and in the MacOS app there is no way, that I'm aware of,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: App cloud sync ?s
If you mouse over a DB a down arrow will appear in the upper right corner of the DB. Click on that and then select reorganize. I've never used the email function so I don't know.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: App cloud sync ?s
Just to be clear, you are talking about iCloud not cloud. if you are then take a look at my comments in this post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Why would a dashboard disappear after saving a dup DB?
I’m guessing you just created a new record in your dashboard table for the fields to show up. Since dashboard tables typically have the table view deleted,…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Invoice item button
I do not know how to close all subwindows. Maybe someone smarter than me will have an answer.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
Try this in a button on the Invoice Item table: let t := this; let newInvoiceItem := (create 'Invoice Item'); newInvoiceItem.(Invoice := t.Invoice); popupRecord(newInvoiceItem) It will open another…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Creating many to many relationship between two tables
I've mocked something up. You only need to focus on the last four tables. The other tables are for another process. If you go to the Results table you can click on the button and see what happens.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
To be clear, you are not in the Articles table. You are in the Invoice table and adding records to the Invoice Item table. You are not adding new articles that is another table and another process.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
It sounds like we are talking about different things. I have a button in the Articles table. You are talking about a button in the Invoice table. If you are in a Invoice record and under Invoice…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
What platform are you on? On the macos app the + button is in the upper right corner. When I click on it a new record appears with empty fields. That happens if I use the + button or my formula…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
I am not sure what you mean by that. When I create a new record it opens a new record to add data. Are you asking if I can exit the new record and select an existing records?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
I guess I'm not understanding your issue. I'm in the invoice template and in the Article table. I've create a button and put: let newRec := (create Article);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Invoice item button
Can you post the code you are using?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Creating many to many relationship between two tables
@Javier One way would be to use a button that would check the M:M table before entering the new data. You can use a dashboard that has a reference field to the other two tables and then have a…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR , how does the new auto complete in v3.6 work with your code? Have you noticed any issues?
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Complex Select statement for View
Ok, so I've worked out what I think is how to do the first two steps. let t := this; let selActions := (select Actions); let xAct := selActions[Actor = t.Actor]; let xTar := selActions[Target = t.…
Attachment
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 103 104 105 106 107 137

Back to top

Overview

View all topics