ScottBurday__Tr
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Why do pipelines have a 12 digit limit for numerical fields?
A simple rule that I learned a long time ago; if you need to do math with the field then it should be numeric. If you do not need to do math with the field it should be text. For items like ICCIDs, serial numbers, etc. there is no need to do any math with the data so it should be a text. Then you are unlimited in the length of the data. ------------------------------ Scott Burday, Trinity ------------------------------15Views2likes0CommentsRe: Calculating Distance from 2 Address Fields
In case you are interested, Trinity develops custom processes to work with Quickbase using actual distance and time calculations. This includes: - Simple point-to-point distance calculations - Lots of different types of mapping processes - Actual routing and scheduling of teams for efficient driving ...and lots more Here is a quick video of a recent implementation of distance and time calculation: https://www.screencast.com/t/hVkEIPf0 Here is a video of a more complex routing and scheduling demo. While you are looking at a custom interface, all the functionality is developed right into the Quickbase app with API calls to Google Maps: https://www.screencast.com/t/xTWOgyb5t If you are interested in discussing further I can be reached at sburday@trinityis.com Thanks. ------------------------------ Scott Burday, Trinity ------------------------------43Views1like0CommentsRe: Native address field map function
Just in case you still need this type of functionality and anything else dealing with geocoding map locations: https://youtu.be/RTIbLBae_do Please reach out to Trinity if you would like to discuss your exact needs: https://trinityis.com/ ------------------------------ Scott Burday, Trinity ------------------------------10Views0likes0CommentsRe: Address map adjust pin and get latitude / longitude
Not sure if you ever solved for this but Trinity does have a solution for plotting the latitude and longitude and being able to adjust it using a pin drop. Here is a video that shows how it is done: https://youtu.be/RTIbLBae_do Please reach out to Trinity if you would like to discuss your exact needs: https://trinityis.com/ ------------------------------ Scott Burday, Trinity ------------------------------20Views0likes0CommentsRe: GeoLocate with Multiple Lat/Long per Form
Mark; thanks for the call out on the work that Trinity has done over the years using GPS data. Alexander; here is a link to a video showing you some of the capabilities that can be done in Quickbase with GPS data: https://youtu.be/RTIbLBae_do Please reach out to Trinity if you would like to discuss your exact needs. ------------------------------ Scott Burday, Trinity sburday@trinityis.com ------------------------------16Views0likes0CommentsInterested in Joining a Quickbase Solution Provider? Trinity Has an Opening
The Trinity team is looking to expand our team as we continue to grow. If you are interested in receiving the job description for a Client Solutions Specialist to develop amazing Quickbase apps for our clients please email: Scott Burday sburday@trinityis.com Find out more about Trinity at: www.trinityis.com Thanks! ------------------------------ Scott Burday, Trinity ------------------------------3Views0likes1CommentRe: Using a barcode scanner to associate multiple existing child records to a parent record.
Ben, While the Quickbase mobile app can scan a barcode and put it into a field, most barcode scanning needs a process behind it to enable workflows that take place after scanning any barcode. So, scan a barcode and then a workflow process occurs that automatically takes the user to the next step. This is always custom development to enable these processes. Trinity has been developing custom barcode driven workflow processes for our clients for 23 years and in Quickbase for 17 years. Our team has developed processes just like you describe above. The productivity and accuracy that comes from barcode scanning is amazing. Either workstation based with USB connected scanners or mobile Android / iOS devices using the camera as a barcode scanner can greatly improve operational capabilities. If you would like to get hold of Trinity for us to show you some of the many barcode driven workflow processes that we have developed please connect with us at info@trinityis.com We would welcome the opportunity to solve this for you. Thanks. ------------------------------ Scott Burday, Trinity ------------------------------12Views0likes0CommentsRe: Chicken Tracking with QB
Steve, I have been working with RFID for 25+ years (even before it was cool) and Trinity develops RFID and barcode scanning solutions in Quick Base for our clients. I love your ingenuity and skunk works for doing this for chicken and egg tracking and your focus on keeping it inexpensive. A few comments: 1. Tracking the time in a coop for a chicken can be done but requires multiple readers. The RFID tag readers need to be offset so one reader reads the tag and then the next reader reads the tag. The two timestamps then determines direction. Then you can calculate when a chicken enters a coop and when they leave. The tag readers you are using now probably do not have the read distance necessary to do this, you will need something more powerful. And no, for others reading this, a more powerful RFID tag reader will not harm the chicken or the eggs. As a note for others reading this, tracking direction using RFID tags can be done other ways with just a single reader. Every train railcar is outfitted with two RFID tags at both ends of the railcar. As the train goes by a RFID reader each tag gets read and depending on what tag gets read first determines direction. 2. Geofencing can work if your coops are far enough apart for differentiation. Geofencing typically uses GPS readings to determine the current location of an item. Typically this is done using Latitude / Longitude and the resolution for this is about 30 feet at best. You can deploy other types of equipment that does not use GPS tracking like Bluetooth or other technologies, but resolution will always be an issue depending on how far the coops are apart. Plus, this will greatly increase the cost and size of what the chickens need to wear for tracking each one. They will not be happy. 3. You may have already figured this out, but when reading a tag you will always get multiple reads at the same time (milliseconds apart) and you will need to filter them down to a single read for that point in time. Some RFID tag readers already account for the software that comes with them but if not, you have to do that programatically so you get 1 read per time block (e.g 5 seconds). Looking forward to more about this over time! ------------------------------ Scott Burday, Trinity ------------------------------3Views0likes1Comment