-
Alert function - trigger after update - cloud version
Hello, i would like an alert after trigger after update. On ipad/iphone this function works ok. On cloud version this doesnt work, when i use the same script with button everything works perfectly.
- Answered
-
Can't see records, while they can be searched and found...
This seems like a basic problem, but I am not to able to solve it. I have a database of wines I have in the cellar, and I retire them by the bottle. So when all bottles of a certain wine have been…
- Answered
-
Find weekends dates
Is there some code to detect weekends in a list of Dates. Now I have a list of 2500 dates records and I need to know which ones are weekends. Thanks
- Answered
-
Parent / Child / Grandchild
Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…
- Answered
-
Carriage Return and Line Feed (CRLF)
Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…
- Answered
-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
Running total every 5 days
I want to sum expanse Sunday to Friday in work week expanse field and ignore Saturday to Sunday I can only sum per week by using week function can’t sum 5 days.
- Answered
-
Display value from unlinked table
Hello. I have a global Value (Exchange Rates) which I want to use in various other tables. So far I have a table called "Exchange Rates). There is a subtable for USD-THB exchange rate which will be…
- Answered
-
Problem in Calc_Dynamic
Hi I have two problems with this models. The Weeks field is Multiple Choice Dynamics can I groups by weeks ? In the example I have two hours on the same week 2.…
- Answered
-
need help with the replace function!!
I get an error on the replace line output2 := ""; let cr := "<br>"; let lr := " "; let myText := myRichText; output := myText; let cText := myText; let cText := replace(myText, cr, lr); let cText :…
- Answered
-
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
-
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
-
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
-
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
-
Dynamic choice field - showing Id instead of description in print view
Some ideas what happens here. Thanks
- Answered
-
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
-
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
-
How to get a filtered sum() from a table-value, where all have a common category?
I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…
- Answered
-
Dynamic Choice triggers twice
When trying to use a 'trigger on update' for a Dynamic Choice field, that actually changes the chosen value, the trigger runs twice. I was under the impression that sensibly a trigger is NOT…
- Answered
-
Duplicating a database deletes internal references
I have duplicated a Database in order to start populating it with data from scratch. One of the tables ('Selezioni') exists only to allow the creation of Cascading Dynamic Choice Fields.…
- Answered
-
Values of Multiple Choice shown as list in print report
Hi guys, Normally when you put the values of a Multiple Choice field in a print report, it's shown as all the values separated by a comma and a space. Is it possible to get the values shown as a…
- Answered
Answer questions and share your knowledge