-
TOP SHELT
Would this work better on Windows 10
-
print attachment
perché quando stampo gli allegati di un modello non sono in formato originale ma appaiono come una miniatura?
-
trigger at the update with integromat
Good morning, I use this formula to send a push notification on my iPhone let webhookURL := ""https://paste-your-webhook-url.here;let data := {RecordID: ID};http("POST", webhookURL, {'Content-Type':…
-
Print layout iPad vs PC
Hi I am finding that when I have a print layout setup it is not exactly the same if printed from a PC or if printed from a iPad , it seems like when printing from iPad the column are narrower then…
-
Using where statement with child or subtables
My database has a parent table: Funds with child table: Balances. Funds has multiple entries, each of which has multiple-year entries in the Balances. I am try to sum the Beginning Balance column in…
-
Réorganise database
Hello, has there been a change in the database menu. There is no longer the possibility of reorganizing the database? Before I had my base on my iPad and Iphone and I could visualize and modify that…
-
Compare data from different records
I need to calculate the difference between data from different records.I have a table with articles, with a unique code that I use as Index called CN.In another table I have dates with stocks of each…
-
How to best get the desired data
Hi all - I have the following tables: Riders - names of riders, country, sex Teams - team names, year active Horses - name of horses, gender, color, passport # Results - jumping results rider,…
-
mise en forme
Bonjour, j'ai créé une BD pour devis. Actuellement, j'ai 4000 articles. Je voudrai, dans le modèle d'impression, concaténer 2 champs, mais avec un retour à la ligne,…
-
How do I add or subtract minutes from an Apointment Start time ?
Hi Lets say I have 3 types of time durations TypeA-15min, TypeB-30min and TypeC-45min. I want to add this duration to the calendar time selected so I would have:…
-
PLEASE - how to ban the possibility of changing the view by users ...avoid add columns
PLEASE - how to ban the possibility of changing the view by users ...avoid add columns - some fields must by hidden (no visible for users), but I can't set the reading by role to field ...…
-
Hp Designjet T120 unknown feature
An [url=https://f2.ae/hp-printers/hp-designjet-t120/]Hp Designjet T120[/url] is a special-purpose printer that is most common for companies that need to print invoices,…
-
create texfile function coding formate
Hello. How can i create text file in cyrillic windows text format?
-
Concatenating all fields in a record
Is there a simple way to concatenate all fields in a record into a string? Of course we can do it explicitly:Field 1 + Field2 + ... But I mean is there a builtin command or function (or any other…
-
Chart - pie
Is there any easy way to show a pie chart with data, for example, how many statuses do I have? 100% all rececord status "done" =? etc
-
Update but only non-existing records
Hi, I am trying to update a subtable but I want that, if it already certain certain records, create only new ones. With the code below if certain records exists, it is duplicating the records.…
-
Scripting a CSV / Excel Export
The Export as Excel / CSV function only allows global access to the function, rather than table by table. It would be good if exporting an Excel or CSV could be scripted into a button,…
-
Force form size
Is there any way to force the size of a form to fill the whole screen when a user clicks on a row of a view ? Jaime
-
Get Line Items From One Table And Add Them To Another On Button Click
Hi, I have a table that contains Orders and in that table is a sub-table Pricing which has to fields - Description and Price.I have created another table named Invoices with a sub-table named Inv…
-
Variable Scope / Empty fields
Hi I am using this code in a "Save" button to avoid empty fields in a record: let MyError := 0; if Nombre = null thendialog("Attention", " ""Nombre"" puedes estar vacío", ["OK"]); let MyError :…
-
Spreadsheet templates
I need to create two databases, one for product inventory control and the other for accounts payable and receivable. Would anyone help me with a model? Lucidio
-
Mac App Crashing
I have the current version of Ninox and Mac OSX 10.15.3. Ninox has been crashing a lot lately. Without warning or any beachball spinning, it is just gone. No crash report to sent.…
-
Boolean If/then/else help needed
I created a simple Boolean if X & Y then A * B else end (sample code below). The idea is for us at our school to only enter date ranges and then have the contribution fees to run the school…
-
I've constructed a database to track revenue and expenses on a number of individual funds. The table titled funds has the general info which is stored in a child called balances and then a grand child called revenue. Each fund has an annual record. I've set up a button to begin a new year and it does start the new balance. It creates a revenue record but connect back to the balance child. Here's the code. Any thoughts?
let currentRec := this;let Nyear := last(Balances.Year) + 1;let Nbeg := last(Balances.'Temp. Restricted-Total');let Nperm := last(Balances.'Perm. Restricted-Total');let i := (create Balances);i.…