ContributionsMost RecentMost LikesSolutionsRe: Number formatting in pipelines. Thanks Prashant for your answer. Think I didn't explain myself. My format numbers are European (actually Brazilian that further complicates UTF-8 issues) A.- In a pipeline I read one number. B.- In another step I copy that number to another table that is also European formatted The number gets multiplied by 10. Seem that in the middle the number is converted to 1234546.78, and in the import process the 2 numbers are in different formats. I thought maybe I could force with a jinja expression to keep the format 123.456,78 (European) I am going to try performing a Bulk upsert to see if that works. When I perform an api call (run import) numbers keep their formats. I remember I had a similar problem with exact forms+ which I solved transforming the number to text format. ------------------------------ eduardo valdes ------------------------------ Number formatting in pipelines. Number formatting in pipelines. I am trying to pass some number values in a pipeline. Simple from one table to another My number formats are 123.456,78. I don't use 123456.78 or 123,456.78 Pipelines only work if the original number format field and the destiny field both are formatted with 123456.78. Other setting multiplies de number by 10. Have tried to look up the record before copying the value. Only works with a run import API call, but I have to complicate the pipeline to use run imports…. Use a shadow table, transform the data and do an api call, merging the tables. Is there a jinja transformation needed that can solve the problem? ------------------------------ eduardo valdes ------------------------------ Re: UTF-8 in Gmail Channel Continue to have the same issue. Would love to make that work. ------------------------------ eduardo valdes ------------------------------ Re: UTF-8 in Gmail Channel Joe, I managed to find a workaround. By the way QuickBase has a native base64 encode and decode function. I tried in a formula field using that formula field in the Gmail body. It didn't work. I was reading the fields of the trigger event. I added another step in the pipelines LOOK RECORD and populated the body of Gmail message with the output of that look record and magically it worked, all the Portuguese diacritics correct. Now I am struggling with the Attachments. Maybe I open another discussion. I have managed to move attachments within QuickBase, using The File handler. I want to: Send a Gmail with an attachment. Link that Gmail with QuickBase record (it seems to have an option). Wait for the customer response to that email. If the response has an attachment identify it and upload it to QuickBase to the linked record. What is not working? a.- I have not succeeded in using the attachments section of Gmail Chanell: Tried a couple of combinations of Type MIME and (file handler/Browser URL) from previous steps. The field that has the PDF in QuickBase is open to EOIT b.-The pipeline identifies the response email, identifies that the response has an attachment, but I have not succeeded in putting it in the QuickBase record. I remember that I did that with QuickBase sync and google drive in the past The error message gives not many clues…… Someone has achieved that? (quite a simple set up for gmail channel), Have read similar things with outlook but not gmail I am sure I must be doing something wrong Thanks ------------------------------ eduardo valdes ------------------------------ UTF-8 in Gmail Channel Have a pipeline that sends a gmail. The body is a field from my table. I can read that field utf-8 encoded in quickbase, but when the email is sent it changes the characters to ascii Using the gmail channel, any known workarround? Thanks ------------------------------ eduardo valdes ------------------------------ Re: pipelin Chayce thanks for your reply. It is working as you say but in a trial mode, (I am learning pipelines). I am using tables with 50 examples. In operation I will be handling tables with 500 entries or more sometimes. My doubt came reading the discussion forums, where someone suggested the pause method Maybe I mis understood. I understand that one sequential api request only starts after the other request ends, when in the same paipeline (same issue I had with promises and coded page. I will retire de pauses, thanks a lot. ------------------------------ eduardo valdes ------------------------------ pipelin I want to run a pipeline that does three steps vi api request: a.Run import opon trigger b.Search some records and delete them or delete via api a certain search qid. Need step a to have finished: c. Run a different import. I have a couple of coded solutions that use this kind of approach. I did that via code using javascript "promises" but i want to keep things with native quickbase tools. I have read some posts but not a definite solution. Someone suggested to introduce a pause between a and b using clock. That will work in 99% of the cases but i am afraid of those 1%. Is there a way to read the output of the api request? maybe when you read no error, you continue with next steps. Thanks on advance ------------------------------ eduardo valdes ------------------------------ Re: Search for unique records pipeline what I do to identify a list of unique values is to create a kind of shadowTable. In your case shadowSection, with only one key field (for example sectionName). You create two formula relations between projects and boreholes, with this shadowTable. The key field should the sectionName. That way you know how many boreholes and projects you have in that section. When you receive the section name metadata you loop and do a prepare, add row, and commit bulk upsert in the same row. That way the shadowTable is updated and you have a table of unique sectionsNames After you can delete that shadowTable. Not a great expert, and don't know if this is optimal but I use it a lot and works for me. ------------------------------ eduardo valdes ------------------------------ Quickbase api in pipeline Back to quickbase after a long period of inactivity. New to pipelines . Have managed to use some functionalities (bulk records and upsert) to import some text files and Google sheets) I want to: after de pipeline finishes processing, the user goes to a certain report or form to manually do some things Suppose I have to use a quickbase api call at the end of the pipeline (last step). Tested without success. Can anyone share the steps os url (generic) needed to achieve this , if this is possible? ------------------------------ eduardo valdes ------------------------------ SolvedRe: SacrebleuSom thoughts about PORTUGUES AND QUICKBASE: Language can be understood perfectly without diacritical. Short message are widely spread and don�t use them. Some banks (Ex a Caixa) do not accept diacritical�s in the transaction!!!! Most important setbacks: a. - Not being able to filter words with diacritical�s. What I do in some cases I have to Data fields. One with diacritical�s to view en another one without just to filter. Would be nice to have a javascript code to substitute before importing and transforming csv. I use some regex such as var valorFormat = row["valorUnitario"].replace("R$", "\ "); var valorFormat2 = valorFormat.replace(/\s+/g, ''); csv_line.push(valorFormat2); But have not managed to be consistent in the transformation. Would be nice to be able to substitute while writing, in SOME ESPECIAL DATA FIELDS THAT YOU PREVIUSLY KNOW YOU ARE GOING TO FILTER b. - After importing something from excel etc. Database gets corrupted with strange signs. Most of this things can be solved by Orienting customers how to set browsers and excel, but there is no a One Place to look at, so we learn by experimentation. ONE IMPORTANT THING: CSV formatting here in brazil is a little bit crazy and does not seem to follow a strict standard. Sometimes comma sometimes semi coma. When exporting form excel you must now what CSV format to use (WINDOWS CSV). Find difficulties in Using quick base native synchronise CSV for that reason. I don�t use it a lot because i usually transform before importing c. - Most users get paralyzed when they see a pop up in �ENGLISH�. There are few pops up so when they learn what it is it is ok. Even though for a deployment I think that service worker translation can be a solution. There isa standard Brazilian keyboard used and if so are there special keys or key combinations used to enter diacritical characters? YES Brazilian formatting conventions are used for(a)date and time and(b)currency values (where are comma's and periods used)? Date ddmmYYY Number xxx.xxx.xxx,xx 4.- In some cases you have to create an extra Formula Field to get things done in table to table import etc but is quite simple.