Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: unknown base type undefined
can you post the code?
- Fred
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD Just a minor change suggestion. Since you need the last record you can get rid of the first() function. let t := this; last((select Table1)[Name = t.Name and 'Date + Time1' <= t.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD said: After a couple of minutes we create record in "TABLE1" Name 'aa' and put any number in field Number . After we make an record in "TABLE2" and in text field 'aa'.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to select current register within 'select' function
There is probably a reason that escapes me and sharper minds can tell us why, but Ninox does not like to use 'this' in filtering. You can put 'this' in a variable.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sum of fields for a period of time
@iliper LTD You are welcome. I got an email yesterday that the Tuesday webinar has been cancelled. Can you post a sample of your db with some records that are inside and some that are outside the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: popupRecord for child record via button
@Carsten Steinmann good to hear. To help others can you post the final code that worked?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort table by month name in numerical month order?
You need to add the month number in front of the month names. You can create a new formula field and put this in the code: format(my_date, "MM - MMMM") This will put a two digit number in front of…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Sum of fields for a period of time
Your xEnd needs a first() or last() function, like in the xBeg, as well, since you are making an array of Date + Time data from the Credit_fill link. let xBeg := last('Hourly Estimation'.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
Looking at the starting post, you have the field 'Interne Nr.' Is that a user editable field? If not then you can try the following in your Titel formula: let x :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
You are close. Can you give me the code for the formula for the Titel field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: popupRecord for child record via button
That is weird. It works for me. I am on the MacOS app, but that shouldn't matter. let selDC := number(dMCTable2); let iDC := item(Table22, selDC); popupRecord(iDC,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Renaming part of title attachment
@thomas said: Unfortunately it gives me an error. I guess it could be because the content of the "title" field is generated by a formula That is your problem.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: v3.7.11 on MacOS does not like Ninext
@Jacques TUR well upgrading to 3.7.12 fixed the issue. It was not available to me yesterday but now it is today.
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 98 99 100 101 102 154

Welcome to the Ninox community

Fred

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?

Re: Sum of fields for a period of time

Re: Sum of fields for a period of time

Re: How to select current register within 'select' function

Re: Sum of fields for a period of time

Re: popupRecord for child record via button

Re: Sort table by month name in numerical month order?

Re: Sum of fields for a period of time

Re: Renaming part of title attachment

Re: Renaming part of title attachment

Re: popupRecord for child record via button

Re: Renaming part of title attachment

Re: v3.7.11 on MacOS does not like Ninext

Overview