Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Does a button only work once ?
I can't think of any, but there are smarter people out there. Does anyone know of the secret self-destruct code? :)
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Does a button only work once ?
It all depends on the code. What is the code?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Code to Generate PO Numbers
I look forward to seeing some ideas around auto-increment the next letter. I've seen numbers but not letters. For the other part you will have to take your date field and create three formula fields…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Holiday day alert
Hi Rob - I don't get any dialog to show up if I put in the Trigger after update. I can get alerts to show up but no dialogs. I'm using the MacOS app. If I put it in a button then dialogs work.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Nice. Will have to remember that.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Try this in a button first: let curRec := this; <--gathers data from the current record in Table1 if Field1 > 0 then <--checks to see that Field1 is greater than 0let xT2 :…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Count similar records in same table
Hi David - Can you give us a sample of your code you are trying to use?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How can I have a formula that counts records from a table?
p is a variable to store the data that you are looking for. In the second line it should read cnt(select [Table Name] where [field name] = p) <-- replacing Table Name and Field Name with your…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Holiday day alert
Please post the code you are using.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Holiday day alert
Please post the code you are using.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Jan Laan
To be clear, when you select, for example, choice1 from your dynamic choice field that is on your invoice table it copies over data from your products table like name and price in your invoice table?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Odd Database behavior
Is DB2 an exact duplicate of DB1, with just different data? Which means all of the tables are named the same and the only thing that has changed is the data in the tables?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How can I link 2 separate database?
The easiest way would be to create a reference field in your table that tracks time and labor to your customer table. It will default name the new field to your customer table name but you can rename…
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: Link record n:1
nice. didn't know that was possible.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Need to Match show rows from a table if email field matches
I was wondering if your code was correct but it isn't. Please change it to: select Events where EmailTo = me.WorkEmail or EmailFrom = me.WorkEmail You were basically saying if EmailTo equal anything.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Need to Match show rows from a table if email field matches
Are you using email fields or text fields for EmailTo and EmailFrom?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Need to Match show rows from a table if email field matches
Please double check the record for 20 Apr 2021, 05:08 to see that the email address is not in either Emailto or EmailFrom.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Link record n:1
Hi Andrea - In your first post you stated that you have a field called FirstTable, so I'm guessing that is the reference field in SecondTable linking it to FirstTable.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Need to Match show rows from a table if email field matches
a bit of background to Fabio's great suggestion: Your code was just missing a way for Ninox to access the current record you are in. Thus the first line of code is to tell Ninox to take the data from…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Link record n:1
What do you mean you want to do it in reverse? If it is a 1:N then wouldn't you always be in your FirstTable and be creating records from there, letting Ninox create the links for you?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: What happens in "Crash"
Wow, that does not sound good. What is the script you are running?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
My first question: are you able to tell which record of each familie group is the principal and which are duplicates? If so then please let us know what field is used to tell the records apart.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
I was thinking that wouldn't it be easier for you to just manually set the "principal" record for each familie? How many could that be? Especially if it is the first time you enter a record for that…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
IsDuplicate Familie is a formula field so you can't put data into it.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
It looks like the code is working to me. Lines 23-25 they all have the same Familie so they would all show up as duplicate. Lines 29-31 look to be singular record with that famiilie so they show up…
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 144 145 146 147 148 157

Back to top

Overview

View all topics