Jan-WillemSpeck
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Downloading file attachments in bulk from an application
If found this link, it's a zip file Index of /files/ Paultrimor remove preview Index of /files/ View this on Paultrimor > But is this tool supposed to still work? I get a error in the app: "ERROR: An Application Token must be supplied." ------------------------------ Jan-Willem Speckmann ------------------------------Re: How to shorten the display of a text field?
Hi there, I used to use a function like below to do this. This has a show more/less function. This code is no longer accepted as is seems to be forbidden Javascript. I also do you like your hover function. it's functional and simple, I was just wondering if there is no way to shorten text and remain the layout (I mean carriage returns) to keep it better readable? Thanks >>>>>>>>>>>>>previous code example>>>>>>>>>>> If([ACT_Memo]="", "", //If [Notes] is blank, display nothing If(Length([ACT_Memo])>300, //If [Notes] is greater than 300 characters var Text a = "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&Left([ACT_Memo],300)&"</pre></span>"; var Text b = "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&NotLeft([ACT_Memo],300)&"</pre></span>"; //"var Text a" shows the first 300 characters from [Notes] //"var Text b" shows the remaining text //The following script is the "more/less" function $a & " <a onclick=\"$(this).hide();$(this).next().show().next().show();\">Show more</a>" & " <span style='display:none'>" & $b & "</span>" & " <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Show less</a>", "<span id="Detail"'><pre style='font-family:"Helvetica","Tahoma","Arial","sans-serif"!important;font-size:100%!important;white-space:pre-wrap!important;'>"&[ACT_Memo]&"</pre></span>")) //If [Notes] is less than 300 characters, display [Notes] <<<<<<END<<<<<<< ------------------------------ Jan-Willem Speckmann ------------------------------Re: API_CopyMasterDetail - how to return to parent record? - API_CopyMasterDetail 0 No error 16 9
Thanks Mark. :-( I feel like there is a candid camera in my office :-( Entered the code : Below how the button looks like on the form (seems code is correct in this context) pressing the button same error again pressing BACK button in browser --> child records copied URL of the 'error page' https://*****.quickbase.com/db/*****?a=API_CopyMasterDetail&destrid=16&sourcerid=13https%3A%2F%2F*****.quickbase.com%2Fdb%2F*****%3Fa%3Ddr%26rid%3D16 ------------------------------ Jan-Willem Speckmann ------------------------------API_CopyMasterDetail - how to return to parent record? - API_CopyMasterDetail 0 No error 16 9
Hi, I have a Parent table PROjects and a child table ACTivities Parent record #13 exists of certain selection of ACTivities and acts as a template record when new PROjects are created. (eventually more templates will follow based on project type) After creating a new parent PROject the intention is to copy the relevant ACTivities from the template via a button pressed by the user when applicable. Using a formula URL field my current code looks like: URLRoot() &"db/" & [_DBID_PROjects]& "?a=API_CopyMasterDetail&destrid="&[Record ID#]&"&sourcerid=13" This works: The ACTivities are added to the new created project PROject. But how to return to the parent PROject? after checking several posts on the form I tried to achieve this by adding & "&z=" & Rurl() But i keep landing on a page with URL: https://*******.quickbase.com/db/*********?a=API_CopyMasterDetail&destrid=16&sourcerid=13&z=cup with the following text API_CopyMasterDetail 0 No error 16 9 on screen pressing the browser 'back' button brings me to the parent record with the correct added child records. PS 1) App tokens have been disabled, this is all happening inside QuickBase 2) I left the ticket parameter empty as following other forum posts there is no reason to worry about tickets when you are already logged into QuickBase. ------------------------------ Jan-Willem Speckmann ------------------------------Suggestions how to manage telephony numberplan
Hi there, are there among you perhaps people who have something like this implemented already or have suggestions how to do it? Basically I consider to build an app to replace a spreadsheet that will become in the end unmanageable and also make the data better sharable with others. It's all around telephony number-plans. In principle the Telecom Provider will provides a range of numbers (by 1's, by 10's, by 100's, by 1000's etc) For example the provider assigns number range 010 2222 36xx which is basically a range of 100 numbers first one is 010 2222 3600 and the last one is 010 2222 3699. We can make it more complicated and it is more complicated as 010 2222 3[67]xx could also be assigned as 2 blocks of 100. Starting at ...3600 en ending at ...6799. And if that is not enough complicated it could also be 010 2222 3[679]xx (note the 8 is missing) which would stand for 3 blocks of 100 starting at ...3600 en pausing at ...3799 and than continuing on ...3900 and ending at ...3999. But let's skip these complications for now. Potentially I'm looking at thousands of number-plans with hundreds of telephone numbers in each number-plan. My primary thoughts were to create two tables. One to keep track of the parent-ranges in use with details like the provider, the circuit, the handover details etc etc. And second a child-table with all the individual telephone numbers that fit in the parent-range and their specific details like who is the user, what specific function is it used for, where is it located, etc etc. My main challenge at this moment is how to create preferable automatically all those individual telephone numbers in the child table once the 'parent-range' is created??? Thanks Jan-Willem PS. 1 I've been looking at an earlier and was wondering if this is possible start. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=8d321e15-bd9a-4f49-b4c9-e89822b6677f&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer 2 To workaround the multiple and broken ranges complication as described above I tend to solve this by simply creating multiple unbroken parent-ranges in the parent-table and most probably join them via a internal link: parent-table --> parent-table 3 Once this is solved my next logical step is something similar for IP-subnets and IP-numbers ------------------------------ Jan-Willem S ------------------------------Re: Automation with table-to-table relationships
Hi John, What you basically suggest is to use the automation to set the status in the request record itself. and a second automation to act on that change. I did not yet consider that approach to be honest but it's worth a try. ------------------------------ Jan-Willem S ------------------------------Automation with table-to-table relationships
Hi there, I'm trying to automate some processes around budgets and projects but can't yet get it working in a simplified test-app. Am I chasing an utopia or should it work and am i doing something wrong? Scenario: I have a projects table: [Projects] and each table has a reference [Projects-Reference] Each project can have multiple changes [Changes] so there is a one-to-many relationship via [Related Project]. Next each change can have multiple requests [Request] so also there is a one-to-many relationship via [Related Changes] and [Related Changes - Status]. A change has a status [Changes-Status] {submitted/approved/rejected} Each request contains fields like [Request-Description], [Request-Quantity], [Request-LocalPrice], [Request-ExchangeRate], [Request-ValueInDollar] , etc. So there are multiple request inside a project that can have different status via the Change table in between. The objective: The requests made are reviewed by he Change they are related too and than as group decided -for example- APPROVED. In that case I would like to copy the relevant Request-fields to a table [Approved] so that the values that have been approved are 'frozen' in the [Approved] table and cannot be messed later on by people that are working inside the project group. The [Change-Status] field is manually changed to {approved} in the [Change] table - based on the change of [Related Changes - Status] field in [Requests] all applicable requests should be copied with the applicable fields to the table [Approved] - a relationship between the relevant Change and the now approved request should be created/copied. So that in the end we can see what what has been approved in the project and at what costs. The challenge: This all sounds simple but in my test app I can't get it working so that the change of [Related Changes - Status] to {approved} triggers the copy of the requested details to the approved table. And when during troubleshooting I use the same rule and with a trigger on a manually changed a test field in the [Request] table it works perfect. I used the 'When the data changes' option on the trigger and the 'Copy record(s)' option on the action and than copy the values of the request fields to the relevant approval fields. I didn't even study on how to copy the relationship yet. The question: Is my scenario and desire possible via 'Automation' at all? Can you use a relationship field as trigger? And can i copy (maintain) that relationship the relevant change? Thanks Jan-Willem. PS as suggested in one of the other related posts i also tried a solution to keep all original data in the request table and work further with filters, reports rules and forms to separate and 'freeze' the approved from submitted and rejected but that leads to an enormous and confusing workaround. ------------------------------ Jan-Willem S ------------------------------Re: Copy Records to new table and Delete with automation
Hi I'm in a similar situation and found this thread as i was orientating for solutions. In my case the situation is about submitted change requests including budgets including currency exchange rates n relation to projects. I was thinking to build something like Mike described in his initial post. Reason to do so is that I need to make sure in some way that projects managers (PM) cannot mess with budgets and details after approvals have been granted I believe this would be easiest to manage to move and thus freeze the data incl costs and exchange rates to a new table where these group of PM's only have read access. I will also build a quick test app around Even's suggestion to see how that works out. Open for suggestions and experiences from others out there who faced similar issues as there is no need to re-invent the wheel. Thanks JWS ------------------------------ Jan-Willem S ------------------------------
