Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Select from another table
Can you tell us the table names and fields you are working with? You can post a screenshot of the Edit Fields window for each table and another of the data model.
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: I need help on Invoicing Table
Where are you copying the "offer" to? If I follow you: 1) you have a record in invoice that starts off with a drop down field = Offer 2) when you switch the field from Offer to Invoice what table do…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Select from another table
It all depends on if you have the necessary fields linked in each table. In your example, FieldFromAnotherTable (FFAT) and AnotherFieldFromAnotherTable (AFFAT) need to be reference fields in…
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: How do I create a new database using the custom tables created by me in another database?
When you open the app or login to the website you will see your DBs, if you hover over the top right corner of the DB icon you will see a drop arrow. If you click on that you will see the option to…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Views are not saved when I close database
Make sure you are in Admin mode (red wrench is active) before you make any changes.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Spam = Garbage = Not Good!
Amen. I email them every time spam shows up. If we all did....
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Retrieve data from a table and display them in other table
Hope you are able to find this amongst the spam. How long has Ninox said they would fix this? Anyways, back to your question. First I'll start with a few of my own questions: 1) just to sure,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
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

1 140 141 142 143 144 153

Welcome to the Ninox community

Fred

Re: Select from another table

Re: I need help on Invoicing Table

Re: Select from another table

Re: How do I create a new database using the custom tables created by me in another database?

Re: Views are not saved when I close database

Re: Spam = Garbage = Not Good!

Re: Retrieve data from a table and display them in other table

Re: Does a button only work once ?

Re: Does a button only work once ?

Re: Code to Generate PO Numbers

Re: Holiday day alert

Re: Automatic record creation

Re: Automatic record creation

Re: Count similar records in same table

Re: How can I have a formula that counts records from a table?

Re: Holiday day alert

Re: Holiday day alert

Re: Jan Laan

Re: Odd Database behavior

Re: How can I link 2 separate database?

Re: Link record n:1

Re: Need to Match show rows from a table if email field matches

Re: Need to Match show rows from a table if email field matches

Re: Need to Match show rows from a table if email field matches

Re: Link record n:1

Overview