ContributionsMost RecentMost LikesSolutionsIf check box is check minus field amount from totalHi 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. Re: If Statement help / Checkbox overridethanks - i'll give this a goIf Statement help / Checkbox overrideI 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], ) Re: External Email Notification to Integrate into Quickbasethanks everyone, i'll take a quick look nowExternal Email Notification to Integrate into QuickbaseWe 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.Re: duration between date created and date modified fieldthis worked perfect - thanksduration between date created and date modified fieldTrying 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]Re: URL button to populate a field with the current userhaha - yes definitely undesrtand that part - thanks :) Re: URL button to populate a field with the current userso in the future if my app application tokens need to be turned on then adding this line will suffice? & "&apptoken=xcxcxcxcxcxcxcxcxcxcxcx" Re: URL button to populate a field with the current userah...some reason app token on the home settings on the app was click on. Thanks for all your help your first solution works just fine now.