Fred

San Francisco, USA

3617
572
5

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

My Posts

Latest Posts

Re: Dynamic combobox/dropdown list
@Kruna said: Is there a way to get the choices sort by 1.group and then by 2.abc? Ninox can not do a multilevel sort with code commands. You have to create another field that combines the two fields…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
@Roger you are correct. sorry, I thought you were to original poster.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna Are you talking about sorting the table view or sorting the choices in a dynamic choice field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
@Roger If you are satisfied with the answer, please mark the post "answered" so others who are looking will know if they should look at the post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering the table view
can you provide a sample db as I can’t seem to reproduce it, even in the iOS app.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Copy "text" field contents into "Choice" field?
If you Choice field is a simple choice field. First you need to make sure there is a choice for all possible data in the Text field. They need to be exactly the same (casing especially).…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna said: what would be the solution, if I use multiple dynamic choice field? Ask and you shall receive.
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Those pesky"" when you don't want them.
Also works with [ ] and ( ). It was a very nice addition to the editor when they made the upgrade.
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- 49
- Get help
Re: Three issues on the Dashboard
@Rafael change all the t.TestToday to today().
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 70 71 72 73 74 145

Welcome to the Ninox community

Fred

My Posts

Re: Dynamic combobox/dropdown list

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

Re: Dynamic combobox/dropdown list

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

Re: Filtering the table view

Re: Copy "text" field contents into "Choice" field?

Re: Dynamic combobox/dropdown list

Re: Those pesky"" when you don't want them.

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

Overview