LB
Qrew Cadet
Joined 4 years ago
User Profile
User Widgets
Contributions
Proxy fields
Is it possible to have fields built in a table be used as individual options based off selections in another table? For example - would it be possible to have a table that houses the item and options and additional options based on the option selected and then relate this have this table relate to another table to display and allow the user to select only certain options and additional options? I've tried to visualize this in a spreadsheet...in the example below if the user selects pink from the options in the proxy field it won't provide any additional options, however if they select green then they will be able to select additional options and so on... Goal options additional options Pick a color? Pink Green Blue Purple Orange Pick another color? Black Red White Pink Teal Hopefully this makes sense... - LBSolved20Views0likes2CommentsAdd button in embedded report
Good evening, I have tabs set up in my parent table records, and in one of those tabs the information is a parent to a child table. I want the purple button to not show for certain case types in a drop down field in the parent record, or if the record has meet the outcome of having 2 reviews completed. Is there a way to do this?26Views0likes1CommentRe: Calculating 1.5 pay
Apologies, let me try to clarify - I have a formula field that will calculate the Total OT Pay based on the Total Hours worked * OT Pay rate...but I also need to calculate based off of an exempt type employee who receives a per-diem rate. I'm not sure how to have the Total OT Pay reflect how much a per-diem person will receive.13Views0likes0CommentsRe: Calculating 1.5 pay
It's a duration field, but now I've also realized I need to calculate hours between date/time fields. I have 2 date and time fields for each day of the week for the user to enter in the date work and time started and another field to enter the date and time work stopped - for each day of the week...how do I total those fields in my TOTAL Hours of OT Worked Duration field?19Views0likes1CommentRe: Calculating 1.5 pay
Thank you! So, another issue I've ran into is trying to find the best way to calculate the total pay the employee was paid based off the Total hours worked... I have a formula duration field that shows the total hours of OT worked based off work start and end times - not sure if I can use the Total Hours of OT worked to calculate the pay based off my OT Pay Rate field that is capturing my time and half pay?29Views0likes0Comments
