Skip to main content

Ninox-Documentation

Jarno Vande Walle

Jarno_Vande_Walle

37
2
0

Joined: 04 Dec 2021

My Posts

Latest Posts

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Thank you Alain; I'm using the cloud version. I've tried the "do as server" in front of the formula but it still takes around 60 seconds to match the results.
- Jarno_Vande_Walle
- 6 mths ago
- Get help
- Reported - view
Re: E-mail Gmail
Hi Sébastien I had A similar situation and created A button to send the mail through the standard mailing app (in which your Gmail account is the standard setting).…
- Jarno_Vande_Walle
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@Alain Fontaine hi again, I tested the new formula and it works very well indeed; somewhat faster than the previous formula. Still; it takes Ninox about a minute or so to match all the data and I…
- Jarno_Vande_Walle
- 6 mths ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Actually Alain, the field value is a formula: creation date + person Id So, one person can have several rows in the subtable (child) , whereas in the parent table it has to match the results based on…
- Jarno_Vande_Walle
- 7 mths ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Hi there I used the code from @Ben and changed "parent" in do j.(parent := item(parentId,i)) into "child" and this has worked very well for some time. Here is the full code: let parentId :…
- Jarno_Vande_Walle
- 7 mths ago
- Get help
- Reported - view
Re: Formula fields show no data in table view
Thank you for the feedback, John. Your previous quote ("Does it include a select command by any chance, as these don't update automatically?") allowed me to solve the problem.…
- Jarno_Vande_Walle
- 9 mths ago
- Get help
- Reported - view
Re: Formula fields show no data in table view
Actually, there is a select command in the formula's that are mentioned in the first section; here's the code: let x := number(Datum) + Medewerkers.Id; first((select Prestaties where 'Uniek nr.…
- Jarno_Vande_Walle
- 9 mths ago
- Get help
- Reported - view
Re: Formula fields show no data in table view
Hi John, There is no select but this formula does refer to another series of formulas; below is the code I'm using. The first first part (if '# werven' = 1 then) are all formulas in the same table.…
- Jarno_Vande_Walle
- 9 mths ago
- Get help
- Reported - view
Formula fields show no data in table view

Sometimes my formula-fields don't show data in some records in the table view and the form view while in others the result is shown. My formula is correct because when renewing the window,…
- Jarno_Vande_Walle
- 9 mths ago
- 5replies
- 141
- Get help
Re: Generate QRCode to File or Image field
Lovely Jacques, I tried it on the app and it works perfectly. In the Cloud version however, I cannot make it work. Is there a particular reason for this, do you think?
- Jarno_Vande_Walle
- 11 mths ago
- Learn & Share
- Reported - view
Re: auto populate email field
Thanks @Mel Charles , but this solution, although a good one, would require me to use the SendEmail({ }), which I don't want to do. In fact, I want to use the "Ninox Email Field".…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: auto populate email field
thank you for the feedback @Mel . However, since my two tables are not parent-child tables, I don't think this solution works for me (I tried imputting the formula but had no results).…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
auto populate email field

Hi guys Is there a way to automatically populate an email field with the mailadres from a person from a linked table? In this scenario I don't want to use the Formula-field because this formula field…
- Jarno_Vande_Walle
- 1 yr ago
- 5replies
- 80
- Get help
Re: Auto-populate field in child table with data from parent table
From my understanding, the ID-field is the one field that is truly unique and cannot be modified. You can however return / show the Id of linked table. Simply create this formula: LinkedTableName.Id
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
@Fred I tried this too but it also doesn't work. I did found out something. When converting the date to a number, I noticed that the number that was entered directly into Ninox differs from the…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
I tried your formula first but that did not yield any result. That is why I changed it.
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Thank you Steven, but unfortunately that does not yield any results. If I change the code that you provided to what follows; I do get the result that was put into Ninox,…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Hi again, entries with the ID 1 to 12 were pulled in from CognitoForms, ID 13 was not.
Attachments
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Yes, enclosed you can find the file. For privacy reasons I made a copy and deleted much of the non-essential info as well as the tables that aren't linked. Kind regards,
Attachment
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Hi Fred; sorry I did not understand your question to deliver a sample. What exactly would you want me to do?
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Hi Fred Here is a print-screen of the formula; the rectangle indicates the relevant parameters for this view; the others are for different views. 'Gepresteerde uren' is the name of the view.
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: Code the top search - Help
Hi everybody, I've used this code too in my dashboard but there is something peculiar. In my table I have entries on August 13 2022 - some were entered directly in Ninox,…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: syntax problems
Thank you Fred; that works perfectly for me! Problem solved
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: syntax problems
Yes, that would make more sense. Indeed; this works! However, is there a way in which the dynamic field is automatically populated by the "date" field in prestaties?…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view
Re: syntax problems
Hi Fred Thank you for the help - I've tried what you said but something is not working. In the table Loonhistoriek I created the dynamic choice field and I get the same result as in your…
- Jarno_Vande_Walle
- 1 yr ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics