PaulElliott
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Strange Problem with Button to mark check box
I've used this same concept in multiple places and they work correctly. I have a couple of apps, and the current app is giving me a strange error message. I'm hoping someone can give me advice on handling this. Code from Button: var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=d7s84zwcx5qf79csb72q6wrdjkd" & "&_fid_20=1" & "&rdr=" & //redirect parameter //URLEncode("https://exteriorsutah.quickbase.com/db/bug9w4puk"); URL meaning URLEncode(URLRoot()&"db/"&"bug9w4puk"&"?a=er&rid=" & [Related Invoice Header]); // Takes them to the invoice header in view mode, dr is view mode er is edit mode "<a class='Vibrant Primary' style=\"width:160px; text-align: center;\" href='" & $url & "'>Select for Pay</a>" Error code being received: <qdbapi> <errtext>Invalid request - we cannot understand the URL you specified.</errtext> <errcode>102</errcode> <errdetails>ac0fb69d-e405-9558-bc99-a5a04c6ca98e:</errdetails> </qdbapi> Thank you, Paul Elliott Exteriors Utah, LLCSum If Function
I'm about done on my first build using Quickbase, I'm looking for something similar to a sumif function where I can summarize a sequence of number fields on a record where I only want to add up numbers greater than zero. There is a sum function and I tried the following without any luck. sum(if([Change Stucco Price]>0, [Change Stone Price]>0, [Change Lap Price]>0, [Change B&B Price]>0, [Change Shake Price]>0, [Change Shutter Price]>0, [Change Corbel Price]>0, [Change Soffit Total Price]>0, [Change Gutter Price]>0, [Change Plaster Foundation Price]>0, ([Change Stucco Price]+[Change Stone Price]+[Change Lap Price]+[Change B&B Price]+[Change Shake Price]+[Change Shutter Price]+[Change Corbel Price]+[Change Soffit Total Price]+[Change Gutter Price]+[Change Plaster Foundation Price]), 0)) I know that this formula doesn't work, but figured I would put it here to give an idea of what I'm looking to accomplish. Any help is appreciated. ------------------------------ Paul Elliott ------------------------------If Statements with inches
So I may have caused myself issues with my setup. But my problem is doing If statements with conditions which have an Inch (") in the name. Ceil(If(="Per Piece", IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/,[Material description]="4" DIAMOND LATH STRIPS",0),0) ) I stopped because I have numerous Material Descriptions which include (") identifier in the name such as the Diamond Lath Strips. I guess I could go through and change all the names to read inch but there's a lot of them. Is there a ' function which allows me to bypass the problem? ------------------------------ Paul Elliott ------------------------------Creating Pipelines
My first attempt into Pipelines and I'm a bit lost honestly. Because I don't have any experience in this, I chose to use the "wizard?". Here's what I have Work Crews, Work Crews are assigned to specific workload records. Workload Records have a crew pay associated with them as well as a completed date and paid date. I create a Work Crew Pay record child to the Work Crew. Work Crew Pay record has a pay period start and end date. I would like to create a pipeline which looks at the Workload Records, makes sure that it's assigned to the associated Work Crew, Check the Paid Date and make sure it's blank, if it's blank check the complete date and see if it falls between the pay period start and end dates. If so then I want to copy the Workload details (multiple fields) including the work crew pay to the Work to be paid table assigned to the Work Crew, hopefully providing a Work Crew Pay Record with multiple Work to be paid records. Essentially looking at all the work performed by the work crew for the pay period and creating a list of workload based records. Then once the information is copied update the Workload Record with the paid date associated with the Pay Date. I've tried using join tables to do it without pipelines, but I wasn't getting to where I wanted to be. Any help is appreciated. ------------------------------ Paul Elliott ------------------------------If then questions
I have a series of If conditions I want to figure out but am getting a boolean error at the end of the statement. If([FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1 if([FC Shake Type2]="Straight Shake",0, //Condition 2 if([City Set Shake Type]="Staggered Shake",[Actual Shake Siding], //Condition 3 if([Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],0),0)),0) Screenshot of formula Error Message: Just wondering where I went wrong in the formula, it looks right to me but there's the error saying I'm wrong. ------------------------------ Paul Elliott ------------------------------
