-
Field txt to date(dd/mm/yyyy)
There are any script to convert a field txt to a date format (dd/mm/yyyy)
- Answered
-
time(time field) problem
I'm in NY, EST. I have a time field "TF" that says: 2:30 PM so time field TF contains 2:30 PM if x := TF then I get x= 9:30 am if x := time(TF) then alert(x) from a button shows 4:30 AM ultimately,…
- Answered
-
Change Status on Multichoice Dynamic
I am trying to get the 'Status MC' change to 90% when I update the date in 'Real 4' but if I delete the date it goes back to 70% 'Status MC'. I try this but don't work.…
- Answered
-
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
-
Conditional email content
Hi every one and Happy new year ! In a database, I have several check boxes and I want to send an email in witch appears only the title list of all the boxes that i've checked.…
- Answered
-
Reference field trigger error
Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…
- Answered
-
Button to Send Message and Create Entry in Log
Hi, can someone help please. I'm almost there. I have this Tab So when I click on 'Join Reminder' button it creates a Text message for sending and this works perfectly.…
- Answered
-
Updating records in the DB
I have several databases, and once a month, i need to transfer information from all databases to a mine database. The problem is, that the data is not updated, it is copied.…
- Answered
-
Double Search
I have a double search formula ( Name & Format) let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray :…
- Answered
-
How do you give a Yes/No field in Chart text names instead of 1/No
I've created a Chart where there is a Yes/No field called PAID where I want to show the Data separated depending on if it is a Yes or a No. However on the Chart is shows up as a 1 or the work No so…
- Answered
-
Questions about code merging.
In the following database, "1" is based on "Data1" to calculate the current state; "2" is based on "Data2" to calculate the current state. I want them to merge and be displayed in "3",…
- Answered
-
Questions about printing invoices
In the database table "Orders", there is a "New document" button. I created a new "test" table and set a "pdf" button. I have an idea that clicking the "pdf" button will generate a "pdf" of the…
- Answered
-
For the question of using N:1 search
When searching for the same content in the same database, there is data returned on the MAC port, but no data is returned on the web port. how are the search keywords defined?
- Answered
-
Regarding the batch write issue.
I created a button to change existing data, but when I click the button, the returned data is always the same. I have tried this many times, but I can't find a solution. I am asking for your help.…
- Answered
-
Verify working time
@Fred Is there a way to verify that a Staff working on two o more Documents does not Spend more than 40 hours. ?
- Answered
-
Help with a search
I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…
- Answered
-
button for Duplicate a record and its links to a sub table
Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…
- Answered
-
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
-
What does this mean?
I have no idea what this alert is trying to tell me. Far less how to fix it. Can anyone give me a clue?! Thank you
- Answered
-
Problem with dynamic report
Hello to the community, Hello everyone, I have a problem with dynamic reports. I created a word document with the tags but my mac application crashes every time I try to test printing.…
- Answered
-
openTable() with sort order.
Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…
- Answered
-
Getting pdf file from the API response
Hello API experts! I would appreciate your help saving/opening a PDF file, which is the response to an API call. This is the code of the API endpoint call inside a button: let url := "https://testeps.…
- Answered
-
Account flows
In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…
- Answered
-
Lead Scoring Assistance
I need some help creating a formula to build Lead Scoring. I have created a formular field in all Lead Records called Engagement Score. I want it to build a score based on their status value with…
- Answered
-
Constraints issue
In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…
- Answered
Answer questions and share your knowledge