Ninox Profile

Technical Help / Copy table (t1) and subtables(s1 and s1.z1) from other table (t2) and subtables (s2 and s2.z2)

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

T

Technical Help / I would like to create a sum formula based on yes/no fields...

Sorry Steven this literally just appeared!

T

Technical Help / I would like to create a sum formula based on yes/no fields...

Any ideas, kind folks!

Ninox Profile

Technical Help / Make a function writable

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.

Ninox Profile

Technical Help / Make a function writable

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

Ninox Profile

Technical Help / Make a function writable

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

Technical Help / Filtering on Summed Value

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

Ninox Profile

Ideas & Suggestions / Dialog with text input

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.

F

Technical Help / Linking and displaying a single field between two tables

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

Ninox Profile

Technical Help / Mac App and iCloud

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

Ninox Profile

Technical Help / Duplicate a field?

Who knows? I'm just a user...

Ninox Profile

Technical Help / Duplicate a field?

Soon?

B

Technical Help / Mac App and iCloud

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.

Ninox Profile

Ideas & Suggestions / Somewhere to share user templates?

Same, I'm happy to share mine with the group as well.

Ninox Profile

Ideas & Suggestions / Dialog with text input

Bump

Ninox Profile

Technical Help / Calculate an amount based on a Number field and a Multiple Choice field

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

Ninox Profile

Technical Help / Duplicate a field?

Νο you can't! Νot yet :-(

Ninox Profile

Technical Help / Like COUNTIFS in Excel

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])

Ninox Profile

Technical Help / Make a function writable

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!

G

Technical Help / Like COUNTIFS in Excel

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