PrashantMaheshw
Qrew Officer
Joined 5 years ago
User Profile
User Widgets
Contributions
[Video] How to identify deleted parent records using relationship magic
Hellos, In this simple video we learn how to identify orphaned children records where parent have been deleted OR identify deleted parent records from orphaned children (very mouthful indeed) Generally we create a pipeline which automagically deletes children records whenever a parent is deleted, in this case due to token expiry , we had tonnes of records where this was not happening . LOOM VIDEO[Snippet]Weekly Updates Excel Sheets to QuickBase
Before we implemented QuickBase , we used to have tonnes of excel sheets were salesman will give weekly update regarding the status of their orders in excel / google sheets. This require creating Creating comments table Creating parent child relationship Limiting two updates in report Speedrun of above is on this , watch at 1.5x LOOM VIDEO with no sound OR You can copy paste below in browser https://www.loom.com/share/1139f233e1a548f4b6c19655c54ddb9e?sid=e477defa-231e-4446-ac35-b9248bdbd6e4Re: Formula help with multiple choices
I am a little confused by the question, you are basically looking to nest multiple ifs together in 1 statement . You want to check value of Salesroom and then decide some calculations against it. Correct?? For your calculation , BODMAS is the way to go essentially it's calculating 3+19.63 , essentially it's doing 3+(1 * 9.63) = 13.63 , your formula will have to become If(([Salesroom])="GS Landsend", ([# of people in party]+1)*9.63) For your multiple ifs , I like keeping it, in syntax below , easier to read If( [Salesroom] = "Pacific Dunes 1", "Pacific Dunes 2", [Salesroom] = "GS Landsend", ([# of people in party] + 1) * 9.63, [Salesroom] = "Playa Grande", ([# of people in party] + 1) * 7.81 ) CONTAINS evaluate TRUE/FALSE , essentially below check if salesroom contains this value or not , if the names are constant = might be better choice that contain If(Contains([Salesroom],"Pacific Dunes 1","Pacific Dunes 2")Re: Formula help with multiple choices
Hi, Can you confirm regarding the formula correction provided 4 days ago ? Your SalesRoom should ideally be containing only 1 value. If( [Salesroom] = "Pacific Dunes 1", "Pacific Dunes 2", [Salesroom] = "GS Landsend", ([# of people in party] + 1) * 9.63, [Salesroom] = "Playa Grande", ([# of people in party] + 1) * 7.81 ) If you must use contains which is a weird case for SalesRoom, then below should be fine. If( Contains([Salesroom], "Pacific Dunes 1"), "Pacific Dunes 2", Contains([Salesroom], "GS Landsend"), ([# of people in party] + 1) * 9.63, Contains([Salesroom], "Playa Grande"), ([# of people in party] + 1) * 7.81 )Re: Date/Time format
I am able to see the time as 02/20/2025 10:24 AM if you enable SHOW TIME in field settings . To show Milliseconds , the only thing which works is having a duration field. If you do decide to convert your time to var duration xyz = Hours(3)+Minutes(20)+Seconds(30); ToFormattedText($xyz,"HHMMSS") Your bigger problem is storing the data , if you store your field as date time it, will only be stored at YYYY-MM-DD HH:MM AM/PM , there is no milliseconds. But we can still show it as 00. Assuming you calculate all timings from midnight, if my DateTime Field Is [All]. This below formula will give you output to 2025-03-13 2:45:00 but it's always 00 var datetime abc = ToTimestamp(ToDate([All]),ToTimeOfDay("00:00")); var duration xyz = [All]-$abc; ToFormattedText(ToDate([All]),"YYYYMMDD")&" "&ToFormattedText($xyz,"HHMMSS") Which means your only option is capture Date then capture Time of day separately . Making sense?
