ContributionsMost RecentMost LikesSolutionsRe: does record picker not work in the grid view?I am also trying to figure out how to make it more user friendly to edit in grid edit mode on this type of issue. When in grid edit, it is displaying the items in chronological order from oldest to newest, and it seems like it should be in reverse chronological order to make the most relevant data at the top of the list in the record picker. Grid Edit needs to be more customizable period. I can go into the properties of the table and customize the record picker items to display, but that doesn't specifically enable me to have the record picker in grid edit be sorted and filtered based on how I want the data to display for ease of use. Is there a fix for this? Re: Reporting a number of days the status of a job was running between 2 custom dates.I like that possibility. During the wait for assistance, I created 2 new Formula Date fields. Reporting Start Date and Reporting Stop Date. The Reporting Start Date field looks at if the actual Start Date field is >30 days ago, it will use 30 days ago as the Reporting Start Date. My formula Max([Start],(Today()-Days(30))) The Reporting Stop Date will look at the Actual End date, and if it is populated it will use it, otherwise it will use Today. My formula Min([End],Today()) Then, I set up to filter the jobs to those that had a Start or End date that is within the last 30 days. So far, I think it is working correctly. Reporting a number of days the status of a job was running between 2 custom dates.I have fields for the following Job ID Status Start Stop At any time, I can get a request to count and report on my job days. My definition of a job day is a job that is running on that day is 1. However, if I need to run this report from the 8th of the previous month through the 8th of this month, I don't want the days the job was still running before or after this date to be counted in the total number of job days. How would I get this to track accurately and be able to pull the report easily. Re: QB App and SAP sharing info back and forth?Thank you so much!QB App and SAP sharing info back and forth?I am writing in hopes of gaining some information, or some education in layman?s terms, of how much 2 way information sharing can take place between QB and SAP. I am curious if SAP can take data entered into my existing Quickbase application and pull it into SAP. Or does an application have to be designed in a completely different manner in order to work with and share information between it and SAP. For instance. We create jobs in SAP and they are identifiable with a unique JOB ID. We then create jobs in Quickbase using this same JOB ID. We do this because the SAP Interface is horrible for the end user and compiling related job data into one view. We would like to be able to tell SAP to get related job information from specific fields in quickbase, and vice versa. I have looked online for a better understanding of how this happens in real-life behind the scenes and what has to be in place to make it work, but I can?t find anything that lays it out in a way that is relatable without a background in database design. I have literally learned as I have gone with Quickbase. In a few days I am having a meeting with many groups to go over my application as a means to get other districts across our company to look into using this application, and exploring the possibility of opening up communication with SAP, but I simply don?t know enough about the IT integration and setup of this behind the scenes in order to know if it is possible and what has to be in place to make it happen. Re: Circular Relationship of tables to display latest applicable reference fieldsOK- this is great! I did the above without an issue and it works great. I can look at my people and see not only who is available, but where each person is currently. Now, to go another step further. Because different people want to see the information in different ways. I have a table created from my "jobs" table that is my "locations" table. Some of this information was used in the lookup fields for resolving my previous posted question. However, this "locations" table is not related directly to my personnel table or my personnel assignments table. Only back to the jobs table. When I open this locations table. I hope to be able to set it up to only show me locations with job status that is either active or upcoming, and display the associated job number, anyone assigned to that job number and their job title. I am thinking that I need to just relate the locations table to the personnel table because now it seems that all the information I need is in the personnel table. However, because this personnel table looked up the location of the person through a separate relationship with personnel assignments I am not sure if it will work. I always create a separate copy when I am trying things like this, but it ends up taking me a long time of trying to find out that they way I did it is not the best way for future use, or it is not possible and I have wasted to much time on it. Furthermore, I struggle with multiple interruptions constantly causing me to have to backtrack to keep track of exactly where I was and what I was doing next in the creation of these. Re: Circular Relationship of tables to display latest applicable reference fieldsIt shouldn't, if it does then someone has not ended an assignment when they moved them from one assignment to the other. When this happens, currently, a number "2" shows as the number of active job assignments for that person which indicates that something needs to be changed. Circular Relationship of tables to display latest applicable reference fieldsI have a table of "jobs". I have a table of "personnel". I have a table of "personnel assignments". On my personnel table, I have creates a status column that shows if the resource is available or on job based on job status and date referencing. When I go to my "personnel assignments" table I can see the details of the related job information that I would also like to display on my "personnel" table. If a person's status is showing as "on job", I want to have an automatic check that the job status is "running", and also display the "Job Name" and "Job Location". All of these are fields that are in the jobs table and can be seen in the personnel assignments table. I want them to be seen on the personnel table. I have created a monster that if I had it to do over again, I would probably do it differently, but the people I have using my app. would not adjust very well.