ContributionsMost RecentMost LikesSolutionsRe: Anyone use Zapier with Quickbase and is having issues ?Actually, I take that back it just the date format d/m/yr format so that's fine. I have had occasional issues that tend to resolve after a little time.Re: Anyone use Zapier with Quickbase and is having issues ?I use Zapier and haven't had problems like this - but one thing that looks strange is the Date Stamp.How To Lookup fields from Child to Parent under certain conditionI know this has been answer many times but not finding the exact post/article to get this working. Parent Record = Opportunity Child Record = System System can have multiple "stages" or even multiple system entries. These change over course of design. Only want to display the system fields on Parent when system (child) has status of "current" And not a related list but a group of fields that are combination numbers/text etc. Basically a reverse lookup but not sure best way to do this - Joined/Third Table? Current Relation ship is - Parent_ Child (Key Field here is Record ID) Opportunity# (numeric key Field) Related Opportunity (Reference) Rel-Opportunity Name (reference proxy) Thanks for your help!Re: Hide Button (link url filed) on form after clickBah that was too easy!! Just added form rule and took care of it. Really appreciate the response. Was over thinking it I guess ;-)Hide Button (link url filed) on form after clickI have a Button on a form (link Url Field) that is used for Approval. It then populates another field that is Text Multiple Choice called Approvals with ex: "[JUN-07-18 IT Support] Approved " and fires off some email notifications etc. I would like this button to not show or be grayed out after it has been clicked once. Were having users repeatedly clicking Approve Button and not knowing they have already approved (not sure why they don't check the status first) so this creates duplicate notifications and confusion. Any help would be appreciated or if this has been resolved in another post if you could point me there. this is the formula on the Button URL Field which works well URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=5t39dmb9j59pjdz6mj9hd55p9rd&_fid_48=Approved&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#])Re: Date Time Format of MM/DD/YYYY HH:MM for integration to GoCanvasah ok - you flipped the 3, 5 Thanks again!Re: Date Time Format of MM/DD/YYYY HH:MM for integration to GoCanvasThank you - this is super close. Made a minor tweak to get it to display right - used 8 instead of 5. But still having issue with the leading zero With below formula: 08:00 displays correctly 08:00 10:00 displays this010:00 Some how need to add zero when time is <10:00 but not display for 10:00-12:00 if that makes sense ToText([Date Scheduled]) &" " & NotRight("0" & Right(ToText([Appointment Time]), 8), 3)Re: Date Time Format of MM/DD/YYYY HH:MM for integration to GoCanvasTried that but problem with "Right" is then I get AM and PM and can't have that.Date Time Format of MM/DD/YYYY HH:MM for integration to GoCanvasBeen going round and round to maintain this format. I cannot pass the AM or PM of the time and would like it to be in 24 hour format but that doesn't hold either. So created formula to take date field and Time of Day field to create the format I need. This works fine except I either lose the leading zero for single digit hours or lose the format if format time ie12:00. This is my formula: ToText([Date Scheduled])&" "&Left("0"&ToText([Appointment Time]),5) This works fine when it is 1:00 because of the added Zero in formula but when I go to 10:00, 11:00, 12:00 its get out of whack.05-12-2018 01:00 - perfect with above formula but if time change to 10:00 I get this05-12-2018 010:0 Basically I need the leading Zero for 1-9 hours but not when 10-12 hours in time of day. Any help is appreciated!