I want to copy T1 and all its sub-registries from S1 and Z1 in to tables T2.S2.Z2 I can copy S1 to S2 but I don't know how to copy table z2 related to S2. Can someone help me? I'm leaving a link for you to download the base I'm working with. https://www.dropbox.com/s/0cfeh5hvmcgoorm/DEMO%20RG.ninox?dl=0 I show the code I execute to copy from one subtable to another. from table S1 to table S2 let t
Sorry Steven this literally just appeared!
Any ideas, kind folks!
Supose you have a yes/no field checkbox 'client' and a numberfield 'price'. The formula in the formula field could be: if client then price else price*1,22 end Steven.
better explanation: the filed "Number" has to be written by me, the field "Formula" is self written dipending on the formula. Can I put something in the formula so that it can be both? Like with an IF function. IF xxxx then the field is "Number" else is "Formula". Thanx
better explanation: the filed "Numer" has to be written by me, the field "Formula" is self written dipending on the formula. Can I put something in the formula so that it can be both? Like with an IF function. IF xxxx then the field is "Number" else is "Formula". Thanx
I am currently using the Ninox Database to store inventory and store their locations in the warehouse. I have a transaction table that stores inventory purchases in (with positive value) values and inventory sales (with negative quantity) value. I want to have a view where I only see items and locations that have inventory (qty > 0). So I created a view where I sum all transactions grouped by item
You're welcome to wait for a response from Ninox support, however, while you're waiting you might want to check out this thread... https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/an-alternative-to-the-input-dialog-5bc40cd413e90e0528f18b5d Hopefully, the date of the thread will offer some perspective.
Hello I have a recipe database and I have starting to link cook-books (another table). Now when "source" is "book", the linked book table entry is displayed. Problem: it pastes ALL the fileds of the table but I only want to select (search bar or drop-down) and display the title. Thanks
You have to pay ONCE for Mac and iPad apps (iPhone app it's free) From Ninox page: Ninox App for MacYou can sync database stored in your iCloud with up to 5 devices per Apple ID. Ninox for Mac works seamlessly with the iPad and iPhone apps. You do NOT need a Ninox Cloud subscription to use the Mac app, but if you have one, you can access all your information from the Ninox Cloud inside the Mac app
Who knows? I'm just a user...
Hi, I've purchased the software, and i do want to synchronize with my iPhone and my iPad, but without using your cloud to i still need to register ? The app for iPad looks like the Mac's software, but the one for iPhone seems to offer only connexion to your cloud. Thanks for help. Best regards.
Same, I'm happy to share mine with the group as well.
Context. Trying to populate a table of days of the month from a 'Costs' table that has known costs of the business. Costs table: Day is a number field. Months is a multichoice field: Table looks like: Over in my Cashflow table I have a button that I want to populate a sub-table e.g.: What I want to do is: Loop through the days for that months 'Daily Cash' table: Loop thorugh the items in the 'Cost
Νο you can't! Νot yet :-(
Like this --- Excel example: =COUNTIF(D5:D12,">100") // count sales over 100 --- Ninox: cnt(select TableName where YourField > 100) or cnt(select TableName[YourField > 100])
Hi, sorry but I am not familiar with coding... I need a function to give a result if TRUE and to leave blank (so that I can insert a different number each time) if FALSE. Exaple: IF the "client" field is YES, let me write each time the final price ELSE (so if he is NOT a "client") make 'price' * 1,22 (add VAT) Thanx in advance!
Team, How do I count the number of times a criteria is met in a field. Basically, the same as COUNTIFS in Excel. V/r