ContributionsMost RecentMost LikesSolutionsRe: Powerapps vs Smartsheet vs Quickbase Are you using the "Per User" or "Per Usage" model? Our "Per Usage" pricing went way up last year, too, but at least I didn't have to pay extra for all of the users who touch the system once every week or two. I agree, though, that the low introductory price and then jacking it up sounds like something else I've heard of. "Go ahead, take a hit of this, or try one of these pills, the first one's free!" ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: I've created a QR Code, now how to I print them all? No problem, I put the YAML for it underneath my description: When a record is created, there is a long URL generated that does what I want with the QR code (in this case, it is adding a record to a different table). The creation of the record triggers the Pipeline, which does a FETCH from TinyURL and "iterates" the return (there is only one record returned) over the record from step A. The information in step C is just some sample data from the first time I ran it so I could get the pattern for the rest. Let me know if this helps! # MPB - Get a TinyURL for the Task QR Code # # Account slugs: # - quickbase[XXXXXXXX]: MPB App <None> --- - META: name: MPB - Get a TinyURL for the Task QR Code tag_names: - MPB enabled: true - TRIGGER quickbase[XXXXXXXX] record on_create -> a: inputs-meta: export_fields: '"URL for Temp Table Scan, TinyURL for Scan In/Out URL" <35, 49>' table: '"MCAS - Midwest Panel Builders: Tasks" <XXXXXXXX>' - ACTION json-handler json_source fetch_json_blob -> b: inputs-meta: authentication_schema: no-auth body: "{ \"url\":{{a.url_for_temp_table_scan|to_json}},\n \"domain\": \"tinyurl.com\"\ ,\n \"alias\": \"\",\n \"tags\": \"\"}" headers: 'content-type: application/json' json_url: https://api.tinyurl.com/create?api_token=YourOwnTokenGoesHere method_type: POST - b<>QUERY json-handler json_object search -> c: inputs-meta: json_schema_sample: "{\n \"data\": {\n \"url\": \"https://sutubra.quickbase.com/db/XXXXXXXX/(_DBID_TEMP_TABLE_FOR_CLOCKING_IN_AND_OUT)?a=API_AddRecord&_fid_7=559&_fid_8=Now&apptoken=YourOwnAppToken&rdr=https%3A%2F%2Fsutubra.quickbase.com%2Fdb%2FXXXXXXXX%2F(_DBID_TIMECARDS)%3Fa%3Dq%26qid%3D8\"\ ,\n \"domain\": \"tinyurl.com\",\n \"alias\": \"XXXXXXXX\",\n \"\ tags\": [],\n \"tiny_url\": \"https://tinyurl.com/XXXXXXXX\"\n },\n \"\ code\": 0,\n \"errors\": []\n}" - c<>LOOP: - DO: - a<>ACTION quickbase record update -> d: inputs: tiny_url_for_scan_in_out_url: '{{c.data_0.tiny_url}}' ... ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table I was trying to figure out what the next serial number should be in a set of records with different airplane types, and each airplane type gets its own serial number with a 3 letter suffix, and the serial numbers increment for that airplane type. Sounds like the perfect use of a maxvalue function...I can't wait! First step was to strip off the letters, which was easy enough using the "notright" function. Then I ranked all of the serial numbers using the great suggestion from Matt Stephens and Quickbase Junkie! First rank all the serial numbers (this is field 42): var Text GTESerial = "{43.GT."&[Number part of S/N]&"}"; //43 is [Number part of S/N] var text SameModel = "{7.EX.'"&[Aircraft or Float Type]&"'}"; //7 is [Aircraft or Float Type] Size(GetRecords($GTESerial & "AND" & $SameModel))+1 This will end up in the situation where, if two airplanes of the same type have the same serial number (gotta do the error checking!), they can both be number 1. So, I used a little math to divide the sum of all the number 1s by the number of records: var Text FindLowest = "{42.EX.1}"; var text SameModel = "{7.EX.'"&[Aircraft or Float Type]&"'}"; (SumValues(GetRecords($FindLowest&"AND"&$SameModel),43) / Size(GetRecords($FindLowest&"AND"&$SameModel))) + 1 Time to put this in my toolbox and thank all the people who came before me and wrote up their solutions! ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table Thanks - I had seen that before and her videos have been extremely helpful to me! I am trying to find the highest value. I can rank them, but if I have 2 records in "first place," I can't do a "sumvalues" to find the highest number. I might be able to do a sumvalue of the highest ranking and then divide by the number of records, though. I'll give that a try tomorrow. ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table I'm trying to use this method and it seems like there is a problem with the logic. Not counting the state part of the equation, if I have records: RID Value 1 10 2 10 3 200 4 100 Record 1 only has 1 record that is GTE 10 and has a RID LTE 1 (itself) Record 2 has 2 records that are GTE 10 and has a RID LTE 2 (itself and #1) Record 3 is back down to 1 record that is GTE 200 and has a RID LTE 3 (itself) Record 4 has 2 records that are GTE 100 and has a RID LTE 4 (itself and #3) I can't figure out how to work the GTE and LTE (as well as LT, GT, XEX, etc.) to get a unique value for RID 3, whether it is a 0 or 1. Any suggestions? Something I might be missing? ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: I've created a QR Code, now how to I print them all? Mike, One of the issues I had with QR codes from Quickbase is that the URL is often super long, which means that the QR code has to be relatively large on the paper to fit all the information in a way that the camera can read it (forget a 150x150 code - too small!). I figured out how to use the API with TinyURL to get a much shorter URL for the long Quickbase ones, which lets me print smaller QR codes. TinyURL's free plan lets you do 600 URLs per month and their paid plans don't cost that much. If you need to shrink the size of your URLs, let me know and I can walk you through the TinyURL API. ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: I've created a QR Code, now how to I print them all? That will be great, Keith!! ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Dashboard Maps are actually awesomeDoes it only do that in Dashboards, or is there a way to get it to have the custom pin icons and colo(u)rs in a stand-alone map report? ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Pipelines - Clear a Dropdown SelectionWere your multiple choice options coming from a list or from a different field? I've had it work when clearing from a list of options, but I can't get it to clear when the options are from a different field. ------------------------------ Edward Hefter www.Sutubra.com ------------------------------ Re: Pipelines - Clear a Dropdown SelectionRESOLVED: The {{CLEAR}} works just fine, but I was trying to clear a formula field rather than the actual text field. Quickbase tech support helped me troubleshoot it. -------------------------------------- Original message: I know this is an old topic, but I am having trouble with both the {{CLEAR}} and the blank field. I have a lookup text field that is pulling values from another field. This field is a list of parent record candidates to copy children records from. After the pipeline copies the children records to the new parent, the pipeline is supposed to clear the field that had the parent record to copy from. I have tried to update the field with a blank text field and I get the message: "Skipped because set values are the same as in source object." This is the YAML line: - a<>ACTION quickbase record update -> f: inputs: part_name_to_copy_sub_components_from: '{{a.blank_text_field}}' When I try to blank it out with the {{CLEAR}} option, I don't get the warning, but I also don't get the field cleared. Here's that YAML: - a<>ACTION quickbase record update -> f: inputs: part_name_to_copy_sub_components_from: '{{CLEAR}}' I can manually clear the field when I am in the form and it is not set that it must be unique or that it must be filled in. Any thoughts or suggestions??? ------------------------------ Edward Hefter www.Sutubra.com ------------------------------