Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

Re: Prefill Field when creating new record
Your code is almost there: let t := this; let newRec := (create 'Segway Guests'); newRec.(Guests.'Date of Tour' = t.Date) popupRecord(newRec); First you have to collect the data from the current…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Constraint for multiple customers
Well of course. Owners is. m:M between customers and items. Just drop the ownermembership reference. if you are still having issues post your code.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Constraint for multiple customers
Since you are actually trying to use the constraints for a reference field, I've come up with: let xCon := concat(b.Owners.OwnerMembership.Customers.Id); contains(xCon, text(a.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Weird issue with DB
I think I figure what is going on. The formula field 'Activities to Bill' gets run once. Then if delete some records in another table through a view, the field in the current table doesn't run again…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Take Date from another Table
I put the following in Fecha_Icicio in Actividades: first('1N_Documentos'.FechaP1) And it retrieves the correct date.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Constraint for multiple customers
Are you talking about the constraint part of a reference field or just using "constrain" as another word for filter. Can you post the code you are working with?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to update a field from a different table?
Most things are possible. I was able to get the following to work in my test DB in a button in table2. Table2 is on the many side to 'toTable12': let t := this; toTable12.Num2 := t.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 1
- Get help
- Reported - view

1 104 105 106 107 108 137

Welcome to the Ninox community

Fred

My Posts

Re: Prefill Field when creating new record

Re: Constraint for multiple customers

Re: Constraint for multiple customers

Re: Weird issue with DB

Re: Take Date from another Table

Re: Constraint for multiple customers

Re: How to update a field from a different table?

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

Overview