olivermah
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
If check box is check minus field amount from total
Hi There, I need some help with an if statement in my field. Currently my [rate total] field is a sum of many fields added all up as below: Sum([Cost - Total],[Markup],,[Stuffing Cost],[Cost - GRI]) I currently have a check box that I want a user to click if they need to subtract a specific amount in another field from the total If [CT LSS collect] = true I need the system to subtract the amount in field [CT LSS] from the total.8Views1like1CommentIf Statement help / Checkbox override
I currently have the following If Statment in my field called [terminal - internal] long story short there comes a time where I need to override this information with the info from another field called [alternative terminal] I've created a checkbox and I wanted to see if I can modify this if statement so that when the checkbox is checked the value in [terminal-internal] becomes the value that in [alternative terminal] I hope this makes sense - pretty much override the the [terminal-internal] with the [alternative terminal] If( [Port of Loading]="Vancouver", [Voyage Dates - Terminal2], [Port of Loading]="Seattle", [Voyage Dates - Terminal 3], [Port of Loading]="Tacoma", [Voyage Dates - Terminal 3], )13Views1like2CommentsExternal Email Notification to Integrate into Quickbase
We receive email notifications on updated dates from one of our vendors. I was wondering if there was any way we can integrate these emails that have specific dates on them to integrate into quickbase to automatically update applicable fields that we specify. This might be right out of left field but i tired searching this in the community but couldn't find anything with my search criteria.15Views1like3Commentsduration between date created and date modified field
Trying to create a formula field where the result shows the difference between the [date created] and [date modified] However I only want it to show the number of hours. tried doing this but it come up with a weird date and time as a result [date modified]-[date created]17Views1like2Comments