Fred

San Francisco, USA

3747
594
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Payment of several unpaid invoices
@Nick said: The tables are: Customers, Invoices, Receipts with the corresponding relationships between them. Can you upload a test DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
is it like this post?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sorting a Table View by Dynamic Choice
I have so many questions that it might be easier to see what is going on if you posted a sample DB.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
@Michael Blechinger You can try adding the array() command to combine the ExpenseTwoMonthsOne and ExpenseTwoMonthsTwo into 1 big array then you don't have to have two loops.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
@Michael Blechinger I didnt know that I loop1 doesnt need to be defined before Yeah, that is where Ninox is different then regular programming languages.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
You need to reference your for loop variable in the loop. for fixeAusgabenTabelle in ExpenseThisWeek do let thisExpense := this.ExpenseThisWeek; let newRec :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss Or you can start a new post. That way we can focus on your question specifically. If you don't feel like writing out the fields and links, you can add a sample DB.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss This post is about dynamic fields. Are you asking how to sort a view element or a table form? Are you using a dynamic field to modify a view element?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with this problem Thank you
@Angel Del Pino VelezI don't do any api work, so I don't have anything to add. To get the most eyes on this issue, I would recommend you start a new post.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss said: but what about sorting the actual data in the grid view? What "grid view" are you talking about?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Thoroughly delete image elements with code
Take a look at this post.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to enforce unique values in text field?
@erik You can look at my sample DB in this post. If you have users use a dashboard/Page then you can control how data gets entered.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Help with this problem Thank you
Hi Angel - Attached is a sample DB. If you open the Dashboard table and the first tab shows you an appointment field and a button. When you select an Appointment then click on the button it will…
Attachment
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Type in a date on 1 table and it populates also in another table
There are two ways to go about it. The first way is to use a Trigger after update on the Date field that copies the data to another date field in another record.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to enforce unique values in text field?
@erikTake a look at this post. You can also use Dashboards/Pages to control some parts of the UI.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to count number of lines and contents
@Peter Oram said: So, formulas 2 & 3 would now need to be how many cells are populated in a certain column. If you can assist with that, that would be great.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to count number of lines and contents
1st - I would like to be able to have a formula to count the total number of doors surveyed You can try something like: count(select tablename) 2nd - I would like to have a formula to count the…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: show only relevant table columns based on two criteria
Test upload of a file.
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: A way to find out where a specific field is referenced anywhere in your tables?
Thanks to@Jacques you can. It is called the Ninext project. DM Jacques for instructions to install. It was indispensable while I reorganized my DB.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: show only relevant table columns based on two criteria
@Richard v. L. I don't see the file.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
@Rafael said: A small video to see the problem. I don't see a problem. The first time you click the button your are on a record with Cod hr = 600 with a final date of 12 Dec 2024.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
@Rafael I don't seem to have that issue. I'm using Public cloud.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
Can you be more descriptive by what you mean "erratically"? Looking at the code it looks like it is doing what you are asking with the data provided.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
@Giovanni Zagarella Have you looked at Alain's code? They are do the same thing but in fewer lines.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
@Giovanni Zagarella said: I have the feeling this is not doable via the switch function though - unless I identified every possible scenario through a line of code,…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 48 49 50 51 52 150

Welcome to the Ninox community

Fred

My Posts

Re: Payment of several unpaid invoices

Re: Duplicate record has stopped working

Re: Sorting a Table View by Dynamic Choice

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Sort Choice (dynamic) entries

Re: Sort Choice (dynamic) entries

Re: Help with this problem Thank you

Re: Sort Choice (dynamic) entries

Re: Thoroughly delete image elements with code

Re: How to enforce unique values in text field?

Re: Help with this problem Thank you

Re: Type in a date on 1 table and it populates also in another table

Re: How to enforce unique values in text field?

Re: How to count number of lines and contents

Re: How to count number of lines and contents

Re: show only relevant table columns based on two criteria

Re: A way to find out where a specific field is referenced anywhere in your tables?

Re: show only relevant table columns based on two criteria

Re: This code works erratically sometimes it works and other times it doesn't

Re: This code works erratically sometimes it works and other times it doesn't

Re: This code works erratically sometimes it works and other times it doesn't

Re: Formula returning specific values depending on multiple choice selection

Re: Formula returning specific values depending on multiple choice selection

Overview