Fred

San Francisco, USA

3743
594
5

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

My Posts

Latest Posts

Re: Design Table for WBS
Hi @Rafael Sanchis Are you trying to manage a project or the documents related to a project? Ninox has a Projects DB template that you many want to look at to see if it might be a good start.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Comments Section
Hi @Katie Rayner - Is the comments section a multiline text field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Repeat Appointments
What do you mean by "repeat appointments? Are you creating a new record that has multiple appointment fields that need to be set upon creation? Are you having to update an existing, or multiple,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Auto populate fields with the value from the previous record?
@Admin Sadly "tomorrow" is not an option. You can do: newRecord.('Order Date' := today()+1
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Put Value Number after Formula
Hi Rafael - Do you have 52 week fields? or Just 9 through 15 that you show in the picture?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Beginner's question
@smarcster Glad you figured it out. I just want to clarify how the mac app version works so you can use it to it full capacity. The app version of Ninox allows you the ability to save your DBs…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Updating the appointment Field after inputing the date
I don't work with dates very much so this was a nice challenge. Here is one solution. You can try putting this in a button to test that it works: let dS := Date + time(11,45); let dF :…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Not equal sign
Hi Simon - A "not equal" sign is !=. So something like if firstname != "Kou" then 1 end For checkboxes, just to be sure you are talking about a "Yes/No" field set to checkbox? If so,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Beginner's question
Another place to look is if your field Ethnicity is a choice field then you would go to Edit Fields then simply edit the field to add a new choice. If you created a dynamic choice field then follow…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Default dynamic choice field
You are correct, there isn't a way to set in the field. One way would be to use Trigger on new record at the table level so when you create a new record it will set it to whatever you want.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR I've never seen the use of the curly brackets. What are you telling Ninox to do with: {y:Year}
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR Always willing to learn a better way, how would you write it? Would you drop the let xSeason and just do it in select Seasons?
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
I'm trying to wrap my head around this. How would you do something like this comparing the value of one array with another? let curRec := this; let xRes := unique(select Results[RiderID = curRec.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Aggreggate like Excel does
Hi Roxana - This sounds like a good place for a dashboard. Check out this youtube video from Nioxus for a good primer on dashboards. For me, once I learned dashboards,…
- Fred
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: How to Reverse Linking between 2 tables ?
I read the question as asking if one can change a reference field from a "Link to" to a "Link from". If that is the question then it is no. You have to create a new field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with Scripting
Hi there - One option is to use the order by command. Since 'Item History' is linked to Transaction you can do something like: let x := last('Item History' order by Date); let xIHDate := x.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
@John Halls Yeah, those were my thoughts as well. I was hoping that I was missing something, which wouldn't be surprising. Maybe I'll submit a feature request to Ninox.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Pass current viewing record Id to a view element column formula

Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
- Fred
- updated 3 yrs ago
- 13replies
- 1020
- 3
- Get help
Re: Other formula problem
Hi Rafael - I am unsure what you are trying to do with your 2nd line. Are you trying to sum the data in a field? Are you trying to set a field to = "Civil"?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
Does the select work in view by itself? maybe the if statement doesn’t return true?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
I was wrong. I just tried it out and your first code is correct. Looking at it again, you have selected records in Jobs that match your search parameters but you don't tell Ninox what do with it.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to import data from text field to dynamic choice field
Hi Alexis - Do you still need help with this?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
You can try: select Jobs where Stato = 2 and 'Stato lavorazione FOTO' = 4 and 'Stato Album' =1 or 'Stato Album' = 3 or 'Stato Album' = 4 No need to repeat the first two since they are the same.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula
do any records show True? if not then shorten the code to just: if FechaR4 <= DataDate then "True" else "False" end If you still do not get any trues then: 1) what kind of field is FechaR4?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula
Hi Rafael - With any if statements are you sure that you are asking correctly? If you change the code to: if FechaR4 <= DataDate and FechaR4 != 0 then "True" else "False" end Do you see the…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 127 128 129 130 131 150

Welcome to the Ninox community

Fred

My Posts

Re: Design Table for WBS

Re: Comments Section

Re: Repeat Appointments

Re: Auto populate fields with the value from the previous record?

Re: Put Value Number after Formula

Re: Beginner's question

Re: Updating the appointment Field after inputing the date

Re: Not equal sign

Re: Beginner's question

Re: Default dynamic choice field

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Aggreggate like Excel does

Re: How to Reverse Linking between 2 tables ?

Re: Help with Scripting

Re: Pass current viewing record Id to a view element column formula

Pass current viewing record Id to a view element column formula

Re: Other formula problem

Re: Syntax stupid question

Re: Syntax stupid question

Re: How to import data from text field to dynamic choice field

Re: Syntax stupid question

Re: Formula

Re: Formula

Overview