-
I want to copy the text content displayed in Formula. Is there a way to do it? Thank you for your reply.
I want to copy the text content displayed in Formula. Is there a way to do it? Thank you for your reply.
-
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
-
join function to get an ordered output
Hi to all i have a formula: let data := text(response.result.relations); let bandData := parseJSON(data); let artists := ""; for i in bandData do let artistType := i.…
-
Automatic adaptation of views
Hello everyone. I would like to know if there is a solution so that the views adapt in height (number of rows) automatically according to their content.…
-
How to clear/null a reference combo box
I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a…
- Answered
-
Fix to resize Console window
I don't know how it all works. I just figured out how to implement the code that Jacques posted here. Thank you very much Jacques. This code can be entered in "Trigger after open",…
-
writable if - otherwise calculate from another field
Hello, I have a numeric field for a measurement in inches, and a second for a measurement in centimetres. When I enter one I would like it to auto-calculate the other.…
- Answered
-
How to create a unique list of records
Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
-
Explanations and examples of Ninox functions available in our docs
We added a separate page with explanations, examples and tips for each of the current 164 functions in our documentation. These pages are currently available in English.…
-
Sending emails reminders automatically in Enterprise version
Hi there. I'm searching the forums but can't find an answer for my needs. We have an Enterprise account, and want/need to send a remainder to our costumers when certain event occurs (time based):…
-
How to action a trigger after form close?
Hi, am wondering how can i action the update trigger after i close the edit window? What is happening it keeps on sending numerous notifications on every field i update which is cumbersome.…
-
Dynamic choice field to autofill text field with values from unrelated table
Hi all, I’ve searched the forum but haven’t found any specific thread so I start this new one. I always used FileMaker Pro (never been a pro user, anyway) and just moved to Ninox so bear with me and…
-
Search view Formula don't work
I Have these Formula for search Ganado Plan but don't work any idea. let Busqueda := Busqueda; select Documentos where 'Ganado PLAN' = " " = Busqueda
- Answered
-
Finding the sum of the last entry given specific text in a field
Sorry for the nonsensical title. I have a table called Bulk Inventory: In a formula in a different table, I want to find the sum of the 'Cumulative (Laa)' values for the final entry of a given month…
- Answered
-
Display extensive datasets via a custom HTML table.
Hello everyone, Following up on my previous post, I am happy to share the lessons I have learned working with an extended dataset. Although Ninox offers many ways to present data,…
-
Icons Problem
I use Ninox in the web cloud version. Lately I've noticed that the style of the icons has changed. At the same time, "styled" functions containing icons and text are no longer displayed correctly in…
- Answered
-
How to select different options in bulk?
I have a table, and I want to select 'Star' as 1 for all 'old code' less than 100, and as 2 for all 'old code' greater than 100. How should I write the code in the button? Thank you for your response.…
- Answered
-
Help with Button that inputs Date into parent record
Chronos is a subtable of Leads. When creating a Chrono, I have made an option that allows a user to push the button to create an "Active Date" that matches with the Date of the Record in the chrono…
-
Bizarre Results from Filtered Records
Ok, this has never happened to me before and is only occurring with one field. I have a simple choice field called 'Reason'. However, when filtering results by choice ID #,…
-
Can't get results to exclude a field value of 0.
I am having more difficulty than I should in having this following formula exclude any records that have 0 value in my 'contact attempts' field let curRec := this; let xStart := 'Start Date';…
- Answered
-
Retrieving the past 14 working days dates
So, I am creating fluid charts on our dashboard. I am having difficulty creating hidden fields that will have the specific #'s to work with. I want these fields to be calculated based on working day…
-
Search and select the most similar text
Hi, I need help to search and select a supplier in a table when I select a reference in another tab. I have 3 tables: one for suppliers one that acts as a register one for imports from another…
-
Coding a popup dialog in a for loop if error
I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…
- Answered
-
the issue of extracting data from parent and child tables.
I have included my question in the ninox file. Thank you!
- 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