-
Convert "Credit Term" to Date plus credit term
Hello. I have 2 fields. CREDIT TERM (number field) DUE (date field) If I add 30 (or any other value) into the CREDIT TERM field, I want the DUE field to auto-update to 30 days from today.…
- Answered
-
Birthday function in tab
when clients are registered, I write down the date of birth. How do I make it so that when a birthday comes up, it will be seen in a different color in the client list. Regards
- Answered
-
Hiding the child table
I would like to hide the child table like 'ProjektStückliste' from the side nav. The user shall only see the child records navigating over the parent table.…
- Answered
-
unknown base type undefined
I have just created a HUD toggle on/off field pair, yes/no toggle with formula to hide icons. I have created a load of them so know what to do. But this error is popping up for a new one I have…
- Answered
-
Create Button PDF
Hi . I have the 3 lines script on the Button (Crear PDF) my report name in Report_1 and need to view it in Emisiones (field pictures), the pdf The script don't work, some help ? Thanks
- Answered
-
Create records after checks on three fields
Hi! I have three tables Tab2 is a fixed table with the following fields: Text Tab2: text field Choice1 - 2: choice field between two options Colour: dynamic choice field Name:…
- Answered
-
field not found - Error
Hi! where is the error? let a := Testo if a = null then let b := "zero" else let b := "molti" end; alert(b) Field not found in line 7 Thanks!
- Answered
-
Copy and open new record
for duplicate last record im us formula let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]); if x = "Yes" then let c := duplicate(this); let t := this; c.…
- Answered
-
Fields shown in calendar
Hey everyone, I started using widely the calendar and realised that only the "Date" field has a setting to "Show in calendar", but I'm using the field "Date+Time" and this one DOESN'T have a similar…
- Answered
-
Next Item in Line Formula
I am creating an approval flow in Ninox. I have a field named 'Current Step' and a list of that displays the order of the steps. Named 'Step Order' and the value is '1,2,…
- Answered
-
Multiply for formula fields
Hi The table has formula fields "Formula 1" and "Formula 2", which, for their part, take information from other tables. I need to multiply "Formula 1" by "Formula 2".…
- Answered
-
Use Tooltip to echo contents of a field.
Probably for the JS/HTML/CSS geniuses @Jacques TUR :-). I have formula field which fetches a note field contents from another table. Because I have to keep the formula field as small as possible the…
- Answered
-
Accumulated by Staff Problem
I have a Problem on Accumulated by Staff fórmula. Example Marianela have 110 hours (104 normal + 6 overtime) but only sum 104 on the Accumulated by Staff. Some help
- Answered
-
ANOTACION EN PDF
Hola, soy nuevo y poco a poco voy creando mi base de control de obras, he visto que la nueva actualización incluye PREVISUALIZACION Y ANOTACIONES EN PDF,…
- Answered
-
Show value of line items depending on the choice field selection
Hello everyone. I have created a formula field to show the current total of our Petty Cash which is in a subtable. This needs to exclude amounts which were transferred to/from a bank.…
- Answered
-
Script to confirm date-time availability
I'm an "intermediate" MacOS app user, with a database to track short-term house-rentals. I need a script to confirm availability or flag date-time conflicts as I enter new bookings.…
- Answered
-
Can I use a "sum" function to add up just the items found through a search?
[Bear with me, I'm still new at anything but the most basic ways to use Ninox.] Here's my case: I've got a simple db set up to catalog a comic book collection.…
- Answered
-
The Formula don't work. For Approval view
let me := this; if 'Rev 0' != null then 'Approved Rev.0' = 0 else if 'Rev 0' is not null then 'Approved Rev0' = 1 else 'Approving Signature' := "Signed by: " + " " + userFullName() + ";…
- Answered
-
Optimize Formula
switch Medicion do case 1: (select DOCUMENTOS where 'Ganado REAL' = 10) case 2: (select DOCUMENTOS where 'Ganado REAL' = 50) case 3: (select DOCUMENTOS where 'Ganado REAL' = 80) case 4:…
- Answered
-
Alert function - trigger after update - cloud version
Hello, i would like an alert after trigger after update. On ipad/iphone this function works ok. On cloud version this doesnt work, when i use the same script with button everything works perfectly.
- Answered
-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Display value from unlinked table
Hello. I have a global Value (Exchange Rates) which I want to use in various other tables. So far I have a table called "Exchange Rates). There is a subtable for USD-THB exchange rate which will be…
- Answered
-
need help with the replace function!!
I get an error on the replace line output2 := ""; let cr := "<br>"; let lr := " "; let myText := myRichText; output := myText; let cText := myText; let cText := replace(myText, cr, lr); let cText :…
- Answered
-
Global Change (yes / no) field
Hi all There are any way to global change the Field yes / no Example is now is No change all registers to yes or otherwise. I Have a lot of registers and manually is annoying. Thanks
- Answered
-
drag and drop an image
Although I never had this problem brfore and given the fact the image field can accept (almost?) any format, in one database, I decided to drag and drop a pdf file (OCRised) of 3 pages...…
- Answered
Answer questions and share your knowledge