-
Fail to Read Data
I get the above error message when I have tried to import CSV files into Ninox. Any suggestions? I am trying this in the Android version. The CSV files come from a windows based Filemaker program.…
-
Convert days to months and years
Hi, I am using the days(date1,date2) function which gives me a result in days. In some results I have a high number like 550 days which is 18 months or 1 year and 6 months.…
- Answered
-
Selecting
Hi I have a table with "date" and a "Type" Ind a function field i want to show the last date with type 2 last(tablename.date) where tablename.type=2 I can get the last date with last(tablename.…
-
Where are my formulas ?
Hi I can't no more see my formulas, only my columns ! How can I retrieve it ? Thanks
-
Query custom
Non si puo in nessun modo fare con questo prodotto delle query custom? faccio fatica a creare dei report come voglio io con gli strumenti disponibili
-
Parse Dynamic Multiple Choice into JSON object
I have a DMC field that takes these values (dynamic value): let all_entities := (select elements); let my_event := this; let my_elements := ((select elements where 'parent entry'.…
- Answered
-
Sum of values of a field of a specific date
I'm looking (and can't find) a solution to calculate the grand total of a field of a given date... No problem illustrating this with a view, but that's no use to me since I need it as a value in a…
- Answered
-
Calculate the most recent date of an activity
Hello, I would like to know if it is possible to have a formula field that allows me to display the date of the most recent activity of a contact (the date of the most recent appointment and not the…
- Answered
-
Choice field: There can be only one!
Hi All, sorry for the daft title. I am trying to establish a rule in a sub-table where only one choice field in all the records can should as active, when that record is set to active all other…
- 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
-
Solutions are there for small hotels
The table has two fields for dates and I can indicate from what day and on what day to occupy a hotel room. But you also need to count those days when he is not busy for the last two months,…
-
Button to validate required fields
Is there a formula to insert in a button that makes me the automatic validation of all required fields displayed in the mask including embedded tables or do I have to make a script on purpose?…
-
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
-
Date of value specific changing
Hello ! I'm looking for how i can get the date of when a value is becoming negative. I'd tried this code : "if 'Value' <= 0 then today() end" but the function today() returns the date of the present…
- Answered
-
Locking and protecting records in a table
Hi Guys I have say a contact table that stores information on an employee, as part of that table I have a link from which contains competencies from another table.…
- Answered
-
Formula fields not appearing in the spreadsheet view
Sometimes formula fields do not appear in spreadsheet view.Even when I click the Show Formula button on a column header and select the formula field to show.Is there any reason for that?
-
Prohibit Deletion
I Heve a task that will prohibit deleting tables and records, APP mac. Found how to hide the delete icon in the bar html(" <style>" + if not HUD then ".i-setting-print{display:none;}" end + " .…
- Answered
-
Using triggers for yes/no field
I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…
- Answered
-
Reference to items in the same table
I am still new to the field of databases so sorry if this question is badly formulated. I have a table 'Items' that lists a large number of items that can be associated to one another.…
-
Client vs Server script differences
Hello all I am building a system for someone and have run into a quirk. As an example, if I have a table called Parent and a child called Child, and both have a number field, Number.…
-
Fill down data in table view
I have done this but now I can't! I have a column of empty data. I was able to entre a value (text in a text field) directly into the table view. Then I could select the field and drag down to fill…
-
CHANIFY
https://www.chanify.net/ Hello, I am trying to integrate Chanify into Ninox to send notifications with links and images. Does anyone have experience with this and can help me write the code for this…
-
Joining text strings with carriage return
I have a clients table where each record has several address fields. Eg. address 1, address 2, city, state, post code, country. I want to join these fields into a single multi-line address but…
-
gráficos
HOLA, ALGUIEN ME PUEDE EXPLICAR COMO FUNCIONAN LOS GRAFICOS, SEGUN VEO EN LA VERSION CLOUD ES DIFERENTE (NO VEO LAS VISTAS). NO SE COMO SE SELECIONAN LOS DATOS PARA EL GRAFICO. GRACIAS DE ANTEMANO
-
Many to Many Relatonships
I am tying to create a Many to Many Relationship Table between Priests & Parishes using the 3rd table named "Priests Parishes". There 300 Priests and 150 Parishes.…
Answer questions and share your knowledge