Fred

San Francisco, USA

3527
551
4

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

My Posts

Latest Posts

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Data not saving
Are u using the macOS app?
- Fred
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: However, I don't understand what I should do next. I know how to create a button but I don't know what I have to add as code so that it can modify the status of each row of…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: But if i want to introduce in addiion to these, client and product id? Take a look at the DB with the Quick View table to see how to add user selected parameters.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
Try the days() function. This will get you the number of days in real numbers. Then you can add a for loop function. There is no way in Ninox to trigger something based on time.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
an appointment field titled "Date du dernier rendez-vous" which matches on the date of the last activity recorded for each account on the activity sub-table How is the field 'Date du dernier…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: For the graph/statistici the table where start from is MOVIMENTI i suppose? That is correct. Take another look at the db file I upload a few days ago to see samples of some codes.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea said: with apple, you didn't need to do anything special to have barcode reading, right?it just works? that is correct. no special software needed.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Automatically change a select field based on a date from another field
do all your appointment times always fall within the same day?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 75 76 77 78 79 142

Welcome to the Ninox community

Fred

My Posts

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

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

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

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

Overview