Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
2590
379
2
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr ago
Get help
Reported - view
Re: Invoice item button
Can you post the code you are using?
Fred
Fred
1 yr 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
Fred
1 yr 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
Fred
1 yr ago
Learn & 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
Fred
1 yr ago
1
Get help
Reported - view
Re: Prefill Field when creating new record
Your code is almost there: let t := this; let newRec := (create 'Segway Guests'); newRec.(Guests.'Date of Tour' = t.Date) popupRecord(newRec); First you have to collect the data from the current…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Constraint for multiple customers
Well of course. Owners is. m:M between customers and items. Just drop the ownermembership reference. if you are still having issues post your code.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Constraint for multiple customers
Since you are actually trying to use the constraints for a reference field, I've come up with: let xCon := concat(b.Owners.OwnerMembership.Customers.Id); contains(xCon, text(a.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Weird issue with DB
I think I figure what is going on. The formula field 'Activities to Bill' gets run once. Then if delete some records in another table through a view, the field in the current table doesn't run again…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Take Date from another Table
I put the following in Fecha_Icicio in Actividades: first('1N_Documentos'.FechaP1) And it retrieves the correct date.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Constraint for multiple customers
Are you talking about the constraint part of a reference field or just using "constrain" as another word for filter. Can you post the code you are working with?
Fred
Fred
1 yr ago
Get help
Reported - view
1
70
71
72
73
74
104
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics