Fred

San Francisco, USA

3622
572
5

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

My Posts

Latest Posts

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
Re: how to project this db
@stef. idea sadly there is nothing I can help with on Android or another product. In iOS the scanning tool is built into Ninox. You may want to email Ninox directly.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
Ok take a look at v3. I changed delivery to returns. There is the item/quantity options and the multi scan option. I left the view element so you can see it working.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@stef. idea for the driver, do you want single item and qnty or multiple scan?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
Here is my latest sample. The Kitchen tab now has two parts, you can scan a single item and enter a specific quantity or you can "scan" in multiple product ids.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: For the Export/Import boffins out there.
boffins? I would like to learn the history behind this. :)
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 79 80 81 82 83 145

Welcome to the Ninox community

Fred

My Posts

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

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: For the Export/Import boffins out there.

Overview