MikeGerrity1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Text fields behavior with quotes and other symbols
Does anyone have a formula for stripping out "curly quotes" from text. A basic searchandreplace does not work because quickbase can't search for curly quotes - but perhaps there is a way to search for the ASCI Character. This has become an issue for me within Pipelines which fail when transfering text that includes curly quotes or other disallowed characters. I have tried using the jinja "escape" feature ie {{a.content_clean|escape}} but that has not made a difference... Thanks for any suggestions ------------------------------ Mike Gerrity ------------------------------Re: Pipeline to remove file attachments
I used your guidance here to create a Pipeline the would delete file attachments in bulk. It seemed to work great - if you look at the file attachment field there is no longer any text showing for the file and there is now thumbnail, BUT the file attachment size for this table was unchanged - despite seemingly deleting about 19,000 photos. What appears to be happening is that I am deleting the current version - BUT the file that had been there simply slides down on the version list (current settings are the default "keep 3 versions"). So the file has not been removed per se and the file attachment space is unchanged (unless I happened to have 3 versions in there previously in which case I assume the oldest one would effectively be deleted). SEE SCREENSHOT. I tried executing the delete button 3 times but that is apparently is not understood by Quickbase as a "new version" - I assume because nothing has really changed for the current version. So now I am thinking the easiest fix would be to change the properties on the file attachment field to only Keep 1 version - I believe all prior versions would be immediately removed but thanks for confirming. Before I take that action thought. I did find this old discussion which seems to suggest there is an additional VERSION PARAMATER that may be helpful. I experimented a little bet with trying to add something like Mark had suggest but got no love. URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_9=" & "&delfile_fid_9=1" & "&vid=1"; I tried several different options for changing the VID but nothing changed the results - a new "deleted version" was added and the older versions were still there. ------------------------------ Mike Gerrity ------------------------------Re: Eliminating Duplicates with a Formula Query
Thanks Mark - I got it to work. Apparently the Query did not like the way my MRN was formatted - likely because of the "." character: sample MRN "1297568.4.3" But when I updated to do the same query based on Patient Name it worked like a charm. ------------------------------ Mike Gerrity ------------------------------Re: Eliminating Duplicates with a Formula Query
Yes - I am part of the Beta and the app I am trying to use is authorized. Should I be seeing a new type of Formula field available? Or am I just using a Formula Text or formula Rich Text field and now have new "formula functions" available? I have tried writing Mark's formula as both a Formula Text and Formula Multi-Select Text field and neither seems to work for me. Not sure if I need to do something further to make sure my app is fully set up for the beta? ------------------------------ Mike Gerrity ------------------------------Re: Eliminating Duplicates with a Formula Query
Mark - thanks for this awesome post - exactly the info I was looking for. One question though: what is the field type for your formula field: GetCellValues(GetRecords("{73.EX." & [NPI] & "}"),3) I have an App that is Beta Approved, and I was expecting to see a new field type that would be "Formula Query" or something like that, but I am only seeing the standard options. Thanks for any guidance! ------------------------------ Mike Gerrity ------------------------------
