Fred

San Francisco, USA

3528
551
4

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

My Posts

Latest Posts

Re: Formula issue
@pirinisz don't worry, we don't judge. my data model for my main db is also a mess as it has grown organically as I've learned. If I redid everything it would be cleaner.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Block a field if ?
@Rafael said: if the Document is 100% no charge more hour to a this Document. Could any of my first suggestions work? What is the relationship between FechaR5 and Horas Hombre?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz actually it would help to see the full DB since we need to see the formulas and relationships. Plus we will all learn a bit of Greek along the way.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Block a field if ?
What do you mean by “block the loading”? If Horas Hombre is a formula field then you can add an if statement that checks if FechaR5 is 100%. Or You can hide the field.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ability to make field layout in form "static"
There are blank spaces you can use instead of empty text fields. If you are in Edit Fields, look under Layout fields. In terms of exact placement of fields, I don’t think that is possible in Ninox.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum related field with specific criteria issue
@Holly M When you get a chance can you post your solution so other people in the same situation can learn from what you did? Thanks,
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Iterate over DC
That is an interesting question. Why would you have a dC if there is only 1 choice? But let us solve the question. You can try this in a button: let x := (select dCTable); let y := item(x, 0);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to Use Constraints
It took me awhile to get a feel for constraints as well. When you open the constraints window you see “a (Log)” and “b (Staff)” on the left side. Depending on the kind of field position is, Text,…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Convert "Credit Term" to Date plus credit term
You should be able to just do as I’m able to do modify a date field on the trigger after update on a number field: Due := Due + 'CREDIT TERM' Since Due is already a date field you don’t need to turn…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Birthday function in tab
If you want to modify text/number in a form then you have to use the styled() command. Check the link for a detailed list of options. You can put it in an if statement to check for if the month and…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Clear out Dynamic Multiple Choices
I’m unsure what you are asking about. You have a table with a dynamic multiple choice (dMC) field and when you create a new record it duplicates the selection made in the current record?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Debug Tracer
Thanks a lot for the warm wishes and the additions to Ninext. Hope you have a warm and sweet Christmas.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: writable if - otherwise calculate from another field
@Rachel Brodie said: but if I enter numbers it reverts to “0” and there is no result in the inches field. I was trying “height_inches := height_cm / 2.54” in the inches field, which did not work.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Searching Multiple Choice Dynamic Fields
It is possible. You can look at this example to see how you need to get the data out of your dynamic multiple choice field. If you have further questions please post a sample of your code and some…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sort / Order by based on total count
You can try: .... let x := for kurzspezifikation in kurzspezifikationen do first(stuecke[Kurzspezifikation = kurzspezifikation]) end x order by Kurzspezifikation I’m just modifying the last part…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: writable if - otherwise calculate from another field
The one issue I see, if you use the writable if, then once you fill in a number in any field it will fill in the other field and now both fields are not writable.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Start with date in a multi line test field
@J. Espí Next time please don’t put your non-code into the code blocks (the grey box). Just type your words in the white space. Put only code examples in the grey boxes.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to Create Checklists / Tasks
Hi @Holly M - Without knowing anything about your DB, all I can say is yes you can do it in 1 table. May I recommend that you create a table, we can call it ChecklistChoices.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Select an element of choice dynamic in formula
@RoSoft_Steven I wasn’t trying to imply any issues with your code, as I depend on you to correct mine. In fact it is what I would use. I’m asking the question to troubleshoot.…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Select an element of choice dynamic in formula
It is interesting that your last example didn’t work. What data was put in Year when you used it?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Different results using Checkbox vs Button to update text field with today() using the exact same code
are you using the Cloud version? testing on the MacOS, I don’t see the problem. When I use a button or Trigger on Update to modify a date field it works with: Date := today() It doesn’t work if I use:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Start with date in a multi line test field
You can try something like: In the Trigger on new record: Comments := today() + " " For me if I just do: Comments := today() It puts in the milliseconds so I added the carriage return at the end and…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Some little Help
Looking at your DB, my question is still the same. let check := dialog(" ATENCION ", " ¿Confirmar la Actualizacion de los Datos en la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Some little Help
@Rafael said: Do you say is not possible ? I didn't say it is not possible. I don't know how everything works so I was just pointing you to where you are setting Data_Date.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Some little Help
You wrote: for loop1 in select WeeksCutOff do Data_Date := loop1.Date; Since loop1 is equal to each record in WeeksCutOff, you then make Data_Date equal to the Date in each record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 85 86 87 88 89 142

Welcome to the Ninox community

Fred

My Posts

Re: Formula issue

Re: Block a field if ?

Re: Formula issue

Re: Block a field if ?

Re: Ability to make field layout in form "static"

Re: Sum related field with specific criteria issue

Re: Iterate over DC

Re: How to Use Constraints

Re: Convert "Credit Term" to Date plus credit term

Re: Birthday function in tab

Re: Clear out Dynamic Multiple Choices

Re: Ninext : Debug Tracer

Re: writable if - otherwise calculate from another field

Re: Searching Multiple Choice Dynamic Fields

Re: Sort / Order by based on total count

Re: writable if - otherwise calculate from another field

Re: Start with date in a multi line test field

Re: How to Create Checklists / Tasks

Re: Select an element of choice dynamic in formula

Re: Select an element of choice dynamic in formula

Re: Different results using Checkbox vs Button to update text field with today() using the exact same code

Re: Start with date in a multi line test field

Re: Some little Help

Re: Some little Help

Re: Some little Help

Overview