-
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
-
How do you create a Google map with multiple locations?
Hi, I want to integrate into my Ninox database a Google map to display multiple locations. Has anyone been able to come up with a functional solution that could be shared here or at least give me…
- Answered
-
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
-
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
-
Count missing dates
Hey all! I'm back with ANOTHER question. Is it possible to use Ninox to count missing dates? For example: on a timesheet I may work August 1,2,3,4,5,7,8,10,11,12,13,14,19,20,22,23,24,25,26,27,…
- Answered
-
Work out annual leave days.
Good morning. I hope you brilliant peeps would be able to help me out again please. I am working on the tables in my database for staff. I am trying to work out annual leave. I have 3 tables.…
- Answered
-
Get the number of the chosen entry in a Dynamic Choise field
Hi, In a normal Choice field you can have a FX field that dispalys the number of the selected choice like this: number(ChoiceFieldName), then the FX displays 0 if emty, 1 for choice1,…
- Answered
-
Formula help
Hi to all! i am trying to activate function through a formula to open specific record. this is the formula: html("<button class='customButton' onclick='openMaster()'>Open Master</button> <script>…
- Answered
-
Sort json?
Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Answered
-
Symbol experted: ")" at Line 46
@Fred @RoSoft_Steven Hi I have a Symbol experted: ")" at Line 46, column Some idea I reviewed the entire script and it only gives me that error
- Answered
-
Sum service amounts from three tables based on dates
Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…
- Answered
-
Trigger on open database
if i put this script into a button on a table form it works. do as server for a in select JobDockets where 'Job Bag' <= 13980 do a.(SupplierQuote := null); a.(SupplierConfirmation := null); a.…
- Answered
-
All I want for Christmas!
Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that…
- Answered
-
Sum Based on Choice
Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…
- Answered
-
Script problem.
do as server let me := this; for i in select 'Task templates' do let new := (create Tasks); new.( void; Status := 1; 'N1 Main Table' := me; 'Assigned Date' := date(year(me.'Start date'), month(me.…
- Answered
-
Not Exit from a loop
Hi to all! i have got this loop on a formula: let images := response.result.images; let coverimageLink := ""; let foundImage := false; for i in images do if (i.type = "primary" or i.…
- Answered
Answer questions and share your knowledge