-
How to write code to batch update data in two or more child tables?
Table2 works if there is only one line of data. However, I need to modify multiple lines of data. How do I modify my code? Uploaded files,Thank you for your help!
- Answered
-
Top left Global search
I never use the Global Search top left because it really does need some refinement by Messrs Ninox before it really comes into its own. For one users need to be able to choose columns.…
-
DB Size Problem
Hello, i'm having issues with my DB that for some reason is over 3.6gb in size and causing therfore problems with our license usage. We mainly store images in our records,…
-
Save record to a log file. error
Hmm can't quit get this right I have a script to cycle through contacts table to emails all contacts. which works perfectly. However I now want to as apart of that email process add a record into…
- Answered
-
How to Update in Batch?need your Help.
I want to batch update the "man" data in table1 to "woman" associated with it, without affecting the data not associated with it. How do I do it? Thank you. File uploaded
- Answered
-
<span onclick> , Is it possible in a Formula (html) with for from to do loop ?
Hi, I have seen resent posts where span onclick is discussed. I wonder if it is possible to implement this in my example. I intedent do upload this as a DB,…
- Answered
-
Limit Input to Rational Numbers in a Text Field
This code can be applied to "Trigger after update" in a text field to limit the input to rational numbers. It does not accept characters other than "-", [0-9] and ".…
-
double entries
Hi Ninox users, I'm looking for: prevent double entries in fields with a warning text popup. How to do this? Can someone help me with this? Regards and thanks Rob
-
in Print pdf when..
如何将这些元素居中? (红线) 谢谢!
-
Relationship between 2 tables - how to?
Hi I'm a musical director with a choir. I need to track which songs are going to be sung at each rehearsal. So I have created a table with all the songs:…
-
Ninox Mac app and macOS 14.0 (Sonoma)
Just to inform you... I just upgraded to macOS 14.0 (Sonoma) mac and the Ninox 3.9.3 Mac app works fine.
-
Triggering an email when a specific has been updated on a table.
I've managed to get the emails sending when the whole table is created/modified etc. But my goal is to only send emails to a specific person, once a specific field has been changed.…
-
Split Function Help
hi to all! I have got this tables in Ninox: TABLE: Genres Field: Genre TABLE: Masters Field (in error): Genre The field in TABLE Master can have 1 or more Genres,…
- Answered
-
Control panel data check
Hi there. Not a coding question as such. @Fred has mentioned using control panels to enter data into the database which I am researching. I have watched the Nioxus videos on this and can see that it…
- Answered
-
Double action button
Hello everyone, I've created a data base witch manage software licence subcriptions. I've added one button that allows to renew the licence. I want that button to add one year to the end date…
- Answered
-
Is there a 'command' to delete an attachment?
I want to have a button that can delete a file attachment (paper clip). Does it exists? I am aware that this might not be possible given there could be more than one attachment but worth asking…
-
Open Record based on UserName
Good morning! I am trying to make my database more user friendly and was wondering the following. I have a table called Timesheet. I have a dashboard too.…
- Answered
-
About code Questions
上面的代码出现了问题,数据变得一样了。 “物流码” HTTPS://M.LZLJ.COM/R/122169506032380086 HTTPS://M.LZLJ.COM/R/122119277562447981 HTTPS://M.LZLJ.COM/R/122121718875948831 HTTPS://M.LZLJ.COM/R /122179735097552622 HTTPS://M.…
- Answered
-
select where statement.
I have two tables, MANUFACTURER and INVENTORY (1:N) In the Inventory table I select the Manufacturer - so far so good. I have added a view which I want to use to display all other inventory items…
- Answered
-
Two Serious Problems... Required Fields & Trigger on new record/update
I just realized there are two serious problems that might be deal-breakers for my business. 1. Required fields don't seem too required. That is to say, I can close a record and it saves (because it…
- Answered
-
Please teach me how to use this global function :-)
This code can be used in global functions and I want to make use of it. I know I can call it from a Form/Tab as needed but how? "--- This controls the HUD icons top right ---";…
- Answered
-
Single Dynamic field that populates other fields
I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…
- Answered
-
"empty" option in Dynamic Field pick list
Does anyone know how to get rid of the system generated "empty" option in a dynamic field list?
-
Need Script for calculating workdays between 1st record, 2nd record, so on.
Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…