ContributionsMost RecentMost LikesSolutionsRe: Get the latest record only on a table relationship That did it! thanks Mark! ------------------------------ Ivan Weiss ------------------------------ Get the latest record only on a table relationship I have a relationship between team member and compensation. It tracks all of the compensation offers to each of my employees. I have a payroll report on the team members table that runs every tuesday showing me everyones payroll to confirm with our payroll service. How do I ensure that it only returns the most recent create date record on that report? Right now it is showing me the highest salary. For some reasons some of the ownership reduced salaries so on the report I want to get the most recent date created compensation record, not the highest salary ------------------------------ Ivan Weiss ------------------------------ Re: Determining current record per employee (payroll compensation history) Hi Don, sorry for the slow response. Heavy travel week! So I could convert to something like this. However, today I do not create a "payroll record". I just run a report off of the team members table. I am not sure I have the need to actually record the payroll as a record although perhaps it would be an interesting idea as if I made the lookup/summary fields snapshots I guess it would record what was paid in that instance. Thoughts on doing it without that payroll table or you think that is the best implementation? ------------------------------ Ivan Weiss ------------------------------ Determining current record per employee (payroll compensation history) Hi everyone, thanks in advance for the help. I have a "Team Members" Table which is a table of all of my employees. It is a one to many relationship with a "Compensation" table where I enter all of the compensation for each employee. On the Team Members table there is a report called "Payroll Sheet" that will be used for bi-weekly payroll. It prints out the team members name, annual salary, bi-weekly salary, which is used for payroll entry. Currently, I am taking the largest salary for each team member on that sheet. However, two of the owners have decided to reduce their salary. So now I do not need the highest salary but I need the most recent (effective date salary). But I cannot just take the highest effective date as it needs to be before the payroll date. This way if we decide to give someone a raise in a month we can enter it now but it will not populate on the report until after that payroll date. So my thoughts are to create a formula checkbox on the compensation table that will be marked check for each employee's salary to use. I have this code in there so far //To be the most current salary the following conditions must be met: // Salary must be the most recent effective date that is before the payroll date per employee If([Effective Date]<=[Payroll Date],true,false) What I cannot figure out is how to limit this to (1) checked entry per Team Member and how to take only the most recent effective date. Any thoughts? ------------------------------ Ivan Weiss ------------------------------ Re: Tabs on iPad Pro Dashboards I sent another bug request and I was told it was "elevated" but not holding my breath ------------------------------ Ivan Weiss ------------------------------ Re: Tabs on iPad Pro Dashboards It is frustrating, I sent in a bug report months ago and nothing thus far ------------------------------ Ivan Weiss ------------------------------ Tabs on iPad Pro Dashboards Any ideas on how to get the tabs at the bottom of dashboards to be visible on ipad? I have a large iPad Pro I use as my primary device when I travel. It displays web sites as desktop version in the browser but tabs dont show for some reason ------------------------------ Ivan Weiss ------------------------------ Re: New Forms - Mobile support That is a bit disappointing they didnt get that out of the gate as it could have a major impact. However, it will take me so long to redevelop these forms one by one it will probably be well into next year before it gets rolled out anyway! ------------------------------ Ivan Weiss ------------------------------ Re: New Forms So I did since figure this out. So now are all of those report links useless? I guess that means in theory I should do a lot of cleaning house on those fields. I happen to like this idea and the fact that it is like a dashboard but wow this update is fantastic but requires a ton of maintenance lol. I wish they had a tool or something to converyt. ------------------------------ Ivan Weiss ------------------------------ Re: New Forms Just adding in my 2cents so that I can follow along but this is where I get SOOOOOOOO frustrated with Quick Base. I was SO excited about new forms. Went in and starting building one as they announced it is GA! And within 2 minutes found a feature not yet developed. Why can't they ever roll out a fully featured update? It is beyond frustrating. ------------------------------ Ivan Weiss ------------------------------