sibling tables

I've been struggling with this for a while but no nearer to a solution so looking for inspiration from here. I have a parent table (p) with 2 child tables (c1 and c2).…

Cannot save views

Hello, I am new to Ninox and the Mac App. I have created my first database with inner and outer joins. When I create a view from a table (i.e. any form or pivot table) I cannot save the view.…

statistics

I have a database in which I have a field "Neighborhood"" another "Type of Property" (e.g.: house, apartment, etc.) and another "range of sq meters"(<70 m2, <100, etc.…

Copy text field to reference field

Hi Brain Trust, Is this possible? I would like to trigger after update a text field (copy a text field) to a reference field. They are both in the same table.…

• Answered

Get time in minutes from the duration field type

How is the formula to get time in minutes from the duration field type? I entered this formula, I expect a value of 60 minutes but I get 0 zero! number(timestamp(format(Durata,…

Storage Full

Bonjour pour résumer, j’ai atteint la fin de l’abonnement, j’ai renouvelé sur l’Apps Store (licence Starter), mais on m’a dit que je devais prendre une licence professionnelle ce que j’ai…

Search by Suppier from  a Choice field

Here again Hi I import a large excel file with 23.652 Items. I try to search by Suppier from a Choice field but I haven't had any luck. Some help On the Search Tab do that with let search :…

• 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

Prevent old record editing for users with limited access rights

Hello! I have 2 access rights levels in my db - admin and manager, where manager has less rights. How can i prevent a manager to change anything in an old record,…

Body of Email field

Hello, Is it possible to add logic within the body of an email field? For instance I am creating an email body with fields from my view, but some I only want to show if another field is ticked…

• Answered

Get Previous Month

Hi, Hopefully a simple one. Im editing the body of when the email field is clicked. Whats the syntax to get the previous month. I have tried everything with no luck. Thanks

Show hide fields on mask...

I have problems with the field display formulas: If the option selected is Pool it shows Category and Customer Fields If the selected option is Robot or Mosquito AND Option Type is selected (shown…

Filter Choice (Dynamic)

@RoSoft_Steven @Fred Hi I have the table with 5 field Choice Dynamic each for one Level of the WBS. All 5 field are Choice Dynamic , each deliverable an Budget is associated with your Level I need…

• Answered

Creating a Button That Goes to Table with only Linked Records

I have been searching endlessly and can't find the correct formula. I want to create a button that when you click on it, it will display the child table but only the linked records to that specific…

Diacritic (¨/ ^ / é / ù ...) and failling researches

Hi, I've experience missed record following a research with a word which includes diacritic. I.e searching for Opera doesn't give records with Opéra. Lazy frenches! but honestly,…

Dynamic choice field - showing Id instead of description in print view

Some ideas what happens here. Thanks

• Answered

Print issues

Hi, I have created some reports in print view mode. I've set the dimensions for the header and according to what I've read, I've placed there the Logo and some text in order to have it repeated on…

WBS Sum budget elements

@@Fred Hello Fred I'm developing a fairly large WBS with 5 levels, I'm using the cascade method, I have a problem with the formula sum of the Budbet of each element of the WBS.…

• Answered

Active or Deactivate specific Budget record

Hi there are some way to active or deactive only the budget on and especific record (example the two red point) Thanks

• Answered

URL's that wrap in Print Layout have broken links

Hi, If I produce a PDF from the Print Layout with a URL field that wraps because it's too long to fit on one line, the link in the PDF breaks - it seems to include the line-break in the link as well…

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

Auto enter current date when a field is updated?

Hello, I am wondering if there's a way to have a date field self populate with the current date whenever I make changes in a field. I have a database with a 'Notes' section,…

• Answered

syntax problems

Hi everybody, I'm hoping that the power of the community could help me out, I've found myself stuck and cannot find the solution to a problem. First some background information:…