Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: forbid multi line copy paste in views ?
@PIERRE M I understand how it the issue works. I guess I would humbly disagree with your comment on “to develop a workaround on that, Ninox would lose most of its simplicity.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
KrunaIf you want to use Jacques' sample then it would look something like: let n := number(Source) switch true do case [1,4][=n]>0: if TaxReqd = false and ResvDept = true then '01Hdr1pymtDep' else ...…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: is there a way to count number of item within a selection field?
Interesting idea. If you are using a simple choice/multi choice field then I would say there is no easy way to count the number of choices. Ninox has no way of looking into the choice field without a…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: adding automatic fees
@Salman If you are satisfied with the results, please mark the post answered to help others.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Formula need
Looking at a DB you sent earlier, the two fields you mentioned, Activities.'Activity Name' and 'History Hours'.'Activity', I don't see any similar data so I don't know how you can find related…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: forbid multi line copy paste in views ?
Wow, I've never tried that before. That is quite the issue. I tried it in a view element and it doesn't do the same thing as a view form. It does mess up that one field but it doesn't copy across…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
You can try something like: let t := this; let newB := create TableB; newB.TableA := t; let newC := create TableC; newC.TableB := newB
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Problem N:1 Activity_Name
@Rafael said: transfer all less the Activitie_Name' only transfer the Number 3 no the Activity Name It is probably because you are not pointing to a text field.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Delete a record and related records in other tables
@Sébastien Guillet that is good. I didn't see it in your code.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Delete a record and related records in other tables
@Sébastien Guillet said: I created a Yes/No field which has the mission of deleting the selected account (record) when I modify the field to Yes. Wow, you are a very trusting guy.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Problem N:1 Activity_Name
Change the Show data as part of the reference field. It is under More Options.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Is it possible to copy/separate tables?
@Allstar Scores said: Then I want to be able to share these smaller tables, so people will only see their group. May I recommend you look into something called dashboards.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding automatic fees
you can use the switch command in the Trigger after update of your choice field. Since I don't know anything about your DB, I'm going to make field names up. Please replace with your own.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Dynamic combobox/dropdown list
You use dynamic comboboxes and constraints. In Ninox contraints usually refers to reference fields. Dynamic choice fields do not use constraints per se.…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Database Search
The best way to do this would be to have a website front end and use a integrator, like Zapier or Make, to allow it to search your DB. Your local veteran association might be able to host it.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Help to figuring out work around for MacOS app

Hi all - For those with access to the MacOS app and a cloud subscription. Upload the attached DB to your cloud account and as a local DB. With the MacOS app: Start with the cloud DB.…
- Fred
- 1 yr ago
- 47
- Get help
Re: Three issues on the Dashboard
@Rafael change all the t.TestToday to today().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Three issues on the Dashboard
Or if you don't want to create a new field you can use the yw field in History Hours. case "Last 2 Weeks": (vInfo := text(sum(base[yw >= yearweek(today() - 7) and yw <= yearweek(today())].…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Three issues on the Dashboard
Trying to use the power of Ninox date fields and looking at your structure you can simplify the code. Ninox does a very good job of adding a subtracting days.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Is it possible to copy/separate tables?
Some food for thought, what is the purpose of the second table if you are storing the same data in two tables? Generally you don't want to store similar data in different tables.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT
@Rijard Take a look at this post about dynamic printing. It is only available for cloud and onPrem users, so if you fall under these two categories then it is time to learn dynamic printing.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Three issues on the Dashboard
@Rafael sorry, forgot that part. yes you will need a year field that uses the same date field as week().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Three issues on the Dashboard
You can try this under the 2 week case: switch true do case week(today()) = 1: (vInfo := text(sum(base[YEAR = year(today() - 1) and 'Week:_' = 52 and (YEAR = year(today()) or 'Week:_' > week(1))].…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Three issues on the Dashboard
@Rafael said: On Show Week Option The add of the Last 2 and 4 Weeks don't give me correct sum. Just to double check, will you have moments when your last 2 or 4 weeks will spread across years?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Three issues on the Dashboard
For the field called Formula under Show Hours - Years / Week you can change the code to: let yweeks := for i in numbers('Select Year/Week') do first((select 'History Hours')[number(Id) = i].…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 62 63 64 65 66 137

Welcome to the Ninox community

Fred

My Posts

Re: forbid multi line copy paste in views ?

Re: Switch Case Statement: combine multiple cases with same code

Re: is there a way to count number of item within a selection field?

Re: adding automatic fees

Re: Formula need

Re: forbid multi line copy paste in views ?

Re: creating linked records from table A to tables B and C question

Re: Problem N:1 Activity_Name

Re: Delete a record and related records in other tables

Re: Delete a record and related records in other tables

Re: Problem N:1 Activity_Name

Re: Is it possible to copy/separate tables?

Re: adding automatic fees

Re: Dynamic combobox/dropdown list

Re: Database Search

Help to figuring out work around for MacOS app

Re: Three issues on the Dashboard

Re: Three issues on the Dashboard

Re: Three issues on the Dashboard

Re: Is it possible to copy/separate tables?

Re: HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT

Re: Three issues on the Dashboard

Re: Three issues on the Dashboard

Re: Three issues on the Dashboard

Re: Three issues on the Dashboard

Overview