Get table info from a dynamic select field

Hi ! I would like to know if it is possible to retrieve data from a table from a dynamic selection field. I have a table named "Produits et services" where I store information about my services sold.…

• Answered

Compile multiple documents into a single pdf

Hi, Is it possible to compile multiple pdfs into one? I have an invoice which is created then saved in my database then, I also have an appendix which is also saved when I generate my invoice.…

• Answered

Display data from a view on a pdf

Hi, I would like to know how to display information from a table view (Edit Fields, Fields, Layout Field -> View) on a word file (.docx) that serves as my template for PDF printing.…

Compare fields of 2 tables to get result

Hi, I have a "Carte-cadeaux" table in which I have the following fields: - "Code de la carte-cadeau" in text format - "Solde restant" in number format From another table named "Paiements" I have a…

• Answered

Duration chart

Hi ! Is it possible to calculate a duration to display it on a graph? I would like to have a graph that displays the time worked each month. This calculation is based on the "Durée" field of the…

• Answered

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,…

• Answered

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.…

• Answered

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.…

• Answered

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.…

• Answered