PrashantMaheshw
Qrew Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
[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?Re: ImportCSV
AS suggested , you can use Python to give output with QuoteALL , which change data from . 2025-12-23,Hello,my friend,hope you are fine "2025-12-23","Hello,my friend,hope you are fine" You will not need to change your delimiter . df.to_csv('output.csv', index=False, quoting=csv.QUOTE_ALL, encoding='utf-8')[Snippet] How we Stop Backdating Entries from user
Starting a new series on sharing some knowledge. We have a simple app where we ask users to do production entries from shop floor daily in date , capturing it in [Production Date] We only wanted backdated entries for 1 day , so if today is 21 February 2025, entry for 20 Feb 2025 is allowed. Here's how we achieved it. Below is a Formula Field called Validations. var date decide = If(IsNull([Record ID#]),Today(),ToDate([Date Created])); var number daydiff= ($decide-[Production Date])/Days(1); If($daydiff<0,"You cannot do entry for future", $daydiff>1,"You cannot do entry for past","OK") We then went to Settings->Advance Settings-> Custom Rules - Turn ON If( [Validation]<>"OK",[Validation] )
