Fred

San Francisco, USA

3418
539
4

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

My Posts

Latest Posts

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
Re: Holiday Greeting
Thanks @Rafael for the warm wishes. It is very nice of you to post this. I hope you have a happy Christmas and a prosperous new year as well.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Renaming part of title attachment
Sorry this is taking so long. Thanks for putting up with my silly questions that you have already answered in your original post. I think I know a solution.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple and Choice fields help
Here is one possibility for a solution. To add tests you click on the Add Tests button and then select the tests according to test category. Let me know if you have any questions.
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Relationship between "Chice" and "Formula" fields
You can try this in your formula field "Discount": switch true do case Choice = 1 or Choice = 2: 0.1 case Choice = 3 or Choice = 4: 0.15 case Choice = 5: 0.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Mileage Chart Spreadsheet to Ninox Table
Here are my two cents. There are five tables: States Cities Trips Log LogTrips (child of Log) The first two do what their name suggests. Trips is where you put in the two cities and the distance.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Multi-Choice (Dynamic) Field
The issue is you have a collection of Ids that you have to somehow iterate through one at a time to get the Employee Name. So you need to put in a for loop.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Code Simplification - Loop ?
Your thinking of using a for loop command is a good direction. Here is one possibility that you can put in a button: let t := this; let xChoice := number(Deduction); let xRec :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Go to a specific record
There is the openTable() function, but it will close the current table and go to the defined table. The only option to leave the current record open and open another is the popupRecord() function.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: unknown base type undefined
can you post the code?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: duration() format?
That is kinda weird. There probably is some good explanation. Maybe it is because it is a time format and Ninox doesn’t know what to do when you try to format what is really a string into a time…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 81 82 83 84 85 137

Welcome to the Ninox community

Fred

My Posts

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

Re: Holiday Greeting

Re: Renaming part of title attachment

Re: Dynamic Multiple and Choice fields help

Re: Relationship between "Chice" and "Formula" fields

Re: Mileage Chart Spreadsheet to Ninox Table

Re: Multi-Choice (Dynamic) Field

Re: Code Simplification - Loop ?

Re: Go to a specific record

Re: unknown base type undefined

Re: duration() format?

Overview