How to enable Javascript

Latest Posts

Re: Indirectly link N:1 records Finally I succeeded. Here is the code if it can help other people. let me := this; let Account := Compte; let newRec := (create 'Bilans de vitalité'); newRec.('Activités' := me); newRec.…
- Sébastien Guillet
- Sebastien_Guillet
- 7 days ago
- 1
- Get help
- Reported - view
Re: Indirectly link N:1 records To explain my request more simply, I would like the "Comptes" linked to the "Activités" record to also be automatically added to the new "Bilan de vitalité" record when I click on the "Créer un bilan…
- Sébastien Guillet
- Sebastien_Guillet
- 7 days ago
- Get help
- Reported - view
Indirectly link N:1 records
Hello ! I have a table named "Comptes", a table named "Activitiés" and a last one named "Bilans de vitalité". When I create a new record in the "Activités" table,…
- Sébastien Guillet
- Sebastien_Guillet
- 7 days ago
- 3replies
- 21
- Get help
- Answered
- Answered
Re: Limit the number of rows visible in a table view @Fred Following your advice to use the where function, I adapted the code and it works which I post below. Thank you again. let filterStart := 'Début du filtre'; let filterEnd := 'Fin du filtre';…
- Sébastien Guillet
- Sebastien_Guillet
- 8 days ago
- Get help
- Reported - view
Re: Breakdown chart by city with filters @Fred This formula works perfectly! I will be able to draw inspiration from this logic for other formulas. Thank you so much !
- Sébastien Guillet
- Sebastien_Guillet
- 8 days ago
- Get help
- Reported - view
Re: Limit the number of rows visible in a table view @Fred I was able to get your code to work however, I forgot to include a condition. Here is the code I am using: let yourSelect := ((select Comptes)['Total facturé'] order by 'Total facturé');…
- Sébastien Guillet
- Sebastien_Guillet
- 9 days ago
- Get help
- Reported - view
Breakdown chart by city with filters
Hello ! I currently use a graph allowing me to know where my customers are located. For the Chassieu city, I only have one client and it is not sufficiently representative to display it in the graph.…
- Sébastien Guillet
- Sebastien_Guillet
- 9 days ago
- 2replies
- 26
- Get help
- Answered
- Answered
Re: Limit the number of rows visible in a table view @Fred Thank you very much, it works.
- Sébastien Guillet
- Sebastien_Guillet
- 9 days ago
- Get help
- Reported - view
Limit the number of rows visible in a table view
Hello ! I have a table view on my dashboard that sorts customers by amount spent. I would like it to display only the 5 customers who made the biggest expenses.…
- Sébastien Guillet
- Sebastien_Guillet
- 10 days ago
- 5replies
- 54
- Get help
- Answered
- Answered
Re: CreateCalendarReminder - Access not granted ---- how did you get around it? I also have this problem with Reminders on Mac. Reminders are added from the Ninox app on my iPhone and iPad but not on my Mac (Intel). The Ninox app does not ask for permission on the Mac so it is…
- Sébastien Guillet
- Sebastien_Guillet
- 10 days ago
- Get help
- Reported - view
Re: Convert days to months and years Thanks for your feedback. I took the code from @RoSoft_Steven then I adapted it with conditions. I notice that it is not accurate because for a date of January 3, 2018 today, I lose 2 days.…
- Sébastien Guillet
- Sebastien_Guillet
- 12 days ago
- 2
- Get help
- Reported - view
Convert days to months and years
Hi, I am using the days(date1,date2) function which gives me a result in days. In some results I have a high number like 550 days which is 18 months or 1 year and 6 months.…
- Sébastien Guillet
- Sebastien_Guillet
- 13 days ago
- 3replies
- 41
- Get help
- Answered
- Answered
Re: Calculate the most recent date of an activity @Fred Perfect ! It works. THANKS
- Sébastien Guillet
- Sebastien_Guillet
- 13 days ago
- Get help
- Reported - view
Re: Calculate the most recent date of an activity @Fred Is it possible to add a condition to the formula? The formula below works fine if I don't have a condition. However, I realize that I need to retrieve the most recent date from the "Activités"…
- Sébastien Guillet
- Sebastien_Guillet
- 13 days ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred Thank you so much ! Your formula works perfectly!
- Sébastien Guillet
- Sebastien_Guillet
- 13 days ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred Hello, maybe you can help me regarding a small problem encountered with conditions. In the previous formulas, there is only one condition (the number of days) however,…
- Sébastien Guillet
- Sebastien_Guillet
- 13 days ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred Thank you very much for your help, it helped me a lot.
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred A double end corrects the error. I tested the button that works. It's great, I will adapt it to push a little more. A big thank-you ! And if I want to automate the function when opening the…
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred When I paste the code in "On click" of the button and I adapt as requested, I have the following error which appears: Expected symbol: end at line 4, column 3 J'ai saisi le code : let sample :…
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred thanks for your help. The "Date du dernier rendez-vous" field of the "Comptes" table is an appointment date format. I have just added the date() function to be able to use the days() function…
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field @Fred yes
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- Get help
- Reported - view
Automatically change a select field based on a date from another field
Hello, I allow myself to seek the help of the community to know if it is possible to modify a field after a defined time. I use Ninox as a CRM (customer management) I have a subtable for activities…
- Sébastien Guillet
- Sebastien_Guillet
- 2 wk ago
- 14replies
- 59
- Get help
- Answered
- Answered
Re: Popup error message @Fred Yes indeed, I just noticed that a global formula (options -> Trigger after opening) was no longer relevant. Your question helped me figure out where the problem was. Thank you so much !
- Sébastien Guillet
- Sebastien_Guillet
- 4 wk ago
- Get help
- Reported - view
Popup error message
Hello, I use Ninox on Mac and I have the following error message when I launch a database: A column was not found: B at line 1, column 150 A column was not found: B at line 1,…
- Sébastien Guillet
- Sebastien_Guillet
- 4 wk ago
- 3replies
- 39
- Get help
- Answered
- Answered
Re: Calculate the most recent date of an activity @Fred Hello, the first method works perfectly. Thank you so much.
- Sébastien Guillet
- Sebastien_Guillet
- 1 mth ago
- Get help
- Reported - view

1 2 Next

Sébastien Guillet

Sebastien_Guillet

27
3
0

Joined: 10 Feb 2023

Follow