Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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
3
replies
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
2
replies
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
5
replies
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
3
replies
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
14
replies
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
3
replies
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
Home
Learn & Share
Get help
Webinars
View all topics
Tags