Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: Take Date from another Table
Looking at an old DB, I see that Actividades has a 1:M relationship to Documentos, 1 record in Actividades has many related records in Documentos. So you don't need to do a select if you only want…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Prices changing in time and data import
About #3, so your sheet has multiple choice fields and calculation fields.? Are your fields in Ninox that relate to the calculation fields in your sheet formula fields?…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Prices changing in time and data import
I thought I would try to mock up a possible solution. Here is how I thought of solving #1 and #2. There is a table called activities with a child table called bySchoolYear and a child of that called…
Attachment
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: after updating to 3.6 from mac appstore, white window.
You should email Ninox as they don’t check these forums too often.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to use the "View" element
I tried something similar: (select Table2)[Date = today()] and it works in a view element for me, so the structure works. It is good that you simplified the code to check the logic.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to use the "View" element
@Admin The table of Guests, is that view element or the actual table name?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Automatically create a record when a date expires
You can try this in a button on the Jobs table: let t := this if DateFieldName < today() then let newRec := (create Workings) newRec.(Jobs := t; DateExpired := t.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Weird issue with DB

Hi all - I'm still on v3.5.14 of the MacOS app. I'm waiting awhile before updating to 3.6. Can you duplicate the following issue? After opening the attached table, click on Invoices.…
- Fred
- updated 3 yrs ago
- 1reply
- 66
- Get help
- Answered
- Answered
Re: Prices changing in time and data import
My thought on #1 is not to duplicate your catalogue for each year but create a child table that tracks price changes per activity. It could be as simple as 1 date field and 1 number field (well of…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to use the "View" element
@Admin The "and t" doesn't make sense to Ninox. You need to provide a field for it to check agains. Try: let t := today(); select 'Snorkel/Sea Scooter Guests' where Tour = 1 and DateFieldName = t or…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem with radio Botton on Web version
3.6 is not out for MacOS yet. I usually wait a few months before I update.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Connect customer to E-Mail - Help
@RoSoft_Steven Rooryck , funny guy.I don't do email so I won't be adding anything. It is all you Steven.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to Duplicate a table also with a subtable
Re-reading your topic again, you talk about subtables. Here is an example of code in a button that will copy the current record you are on. Here is my structure.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to Duplicate a table also with a subtable
so if you put the for loop in a button by itself and run it no new records are recreated? You can also modify it so you don't have to repeat the variable: k.(Items := j.Items; Description := j.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: 2 questions about views
I guess I wasn't clicking on an editable field. Now if they can do that with the view element.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Single user, multiple Macs
You can install it on multiple mac as long as you have the same iCloud account attached to each Mac. While you can edit on different machines, you will have to do an extra step each time you want to…
- Fred
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: How can i get totals from a job type?
Just thinking out loud about some limitations. If you decide to do things differently then we are here to help.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: 2 questions about views
Well there you go. For you cloud users you can. Sadly us app users do not get that ability.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Read only table
Most of us are self taught, so welcome to family. I won't bother with the manual. It is only good as a reference. I've learned most of knowledge from the Nioxus videos and this forum.…
Attachment
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Read only table
So Logbook table is the one that needs to be write protected? If invoices are created from Logbook then it sounds like you are constantly making edits to Logbook as you add/sell items.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: 2 questions about views
@Gianluca Sorry, didn't mean to sound like I was scolding you. Just wanted to let you know that you are not the only one that wants this ability.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Read only table
I thought you were copying existing data from existing tables into the Logbook table, then you want to lock the table. The example you gave shows you are referencing fields in other tables.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Read only table
How are currently copying the data to the warehouse table? What does the current code look like?
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: 2 questions about views
1) you have to have some view, but you don't have to have the default table view. deleting views doesn't affect data, just how you interact with your data.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: trigger a field in subtable from field in mother table
What does your new code look like? Can you put it in a button so you can trigger it on your command? With something so complicated, can you create a new field and simplify it.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view

1 112 113 114 115 116 145

Welcome to the Ninox community

Fred

My Posts

Re: Take Date from another Table

Re: Prices changing in time and data import

Re: Prices changing in time and data import

Re: after updating to 3.6 from mac appstore, white window.

Re: How to use the "View" element

Re: How to use the "View" element

Re: Automatically create a record when a date expires

Weird issue with DB

Re: Prices changing in time and data import

Re: How to use the "View" element

Re: Problem with radio Botton on Web version

Re: Connect customer to E-Mail - Help

Re: How to Duplicate a table also with a subtable

Re: How to Duplicate a table also with a subtable

Re: 2 questions about views

Re: Single user, multiple Macs

Re: How can i get totals from a job type?

Re: 2 questions about views

Re: Read only table

Re: Read only table

Re: 2 questions about views

Re: Read only table

Re: Read only table

Re: 2 questions about views

Re: trigger a field in subtable from field in mother table

Overview