Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: Formula ID count also deleted records
Can you post the code from your formula field and gives us the names of important fields and tables?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Limit the number of rows visible in a table view
You can take your select and then use the count() and slice() functions. let yourSelect := select.... order by expensesfieldname let cntofSelect := count(yourSelect) slice(yourSelect,cntofSelect-5,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea moving forward it probably be best to start a new post with further questions. I don’t think anyone can follow this in the future.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: how you resize the field? In admin mode, select the field and you see squares on the two short sides of the field. Drag the squares to change field size.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: ..a list of the most returned and most sold take a look now, there is a new View element that points to ‘3_Article’ table and then shows a summary of sold and returned by record.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: one thing..starting from this quick view table...will be able to see it in a grapgic manner..according to the query i do? I don’t think you can do a whole lot with the Quick View,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea ok i copied over the gatherData code from my copy.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Change the field type afterward
@Hamad Gamal Welcome to Ninox. We would love to help you as best we can. May I recommend that you start a new post and give us a bit more detail of what you want to do.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea You should try to recreate in v5. The use of the hidden field "gatherData" saves you from having to copy the big string of code for each summary field you want to create.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea I've updated v5 with a button that allows for no space in between the product codes. It is dependent on the product codes being 5 digit/letter long.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: I see tere is nothing about product yet...wht ado you think of my attempt with code? It is a good start. In v5, make your modification to the gatherData field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea I'm confused. I was responding to your opinion that the work flow was too difficult. I was just coming up with other options. If you think the driver would be Ok with what is designed…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea These are only crazy ideas of mine as I have not actually done anything like this in a real work environment. With that in mind, my two cents: 1) driver opens a google Sheet,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Convert days to months and years
Here is one possibility. The big limitation is that it assumes all months are 30 days long, so it starts to lose accuracy very quickly the further out in time it goes.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea On scanning, you have to add a space between scans as the scanning part of the app doesn’t do it on its own. If you keep scanning then it will make one long string.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: but for what i have seen this possibility is only theory..because to have a real update, the user must refresh everytime the db. To the best of knowledge,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calculate the most recent date of an activity
@Sébastien Guillet said: However, I realize that I need to retrieve the most recent date from the "Activités" table provided that the select field named "Type de rendez-vous" is different from 5.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: changing the status to number 1 should not be done if the status (selection field) is 3 or 9 or 10. Looks like you put the conditions in the wrong place.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: MAJOR problem (v3.7.14 Mac)
@up878844 said: I was going to upgrade my account tonight So this was happening on a cloud stored version? It was previously reported to happen only on iCloud stored DBs.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
Take a look at v4. I’ve updated the Quick View table to show one way of doing the data analysis. there is a hidden field called gatherData that figures out the which fields got used and then to find…
Attachments
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Data not saving
Are u using the macOS app?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
If you still think the return process is too cumbersome for the driver, can the driver scan the info into a spreadsheet that you can import daily?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: where i can select form a dropdown menu the client, the product id and the range of time and have returned different statistics? Yes you can do this.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: And if I want to automate the function when opening the database (and no longer with a button), where should I add the code? Is it the same or does it have to be adapted…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: I have the following error which appears: Expected symbol: end at line 4, column 3 For forgot the end to close the if statement. Add an end at the very end of the code.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 70 71 72 73 74 137

Welcome to the Ninox community

Fred

My Posts

Re: Formula ID count also deleted records

Re: Limit the number of rows visible in a table view

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: Change the field type afterward

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: Convert days to months and years

Re: how to project this db

Re: how to project this db

Re: Calculate the most recent date of an activity

Re: Automatically change a select field based on a date from another field

Re: MAJOR problem (v3.7.14 Mac)

Re: how to project this db

Re: Data not saving

Re: how to project this db

Re: how to project this db

Re: Automatically change a select field based on a date from another field

Re: Automatically change a select field based on a date from another field

Overview