ContributionsMost RecentMost LikesSolutionsRe: Possible to open a quickbase link in the App (versus browswer) on Mobile? Hi Mike, Thank's for this post, gave me hope I can force the links in my QB Notification emails would open in the QB app on the addressee's device. Did the settings as advised, still it only works if the app is not open yet! If app is already open link stares at an empty page... I only have access to a Samsung tablet, no idea how this would work on iOS. Any experience to share? Can there be any change in the link construction to force the open app to correctly accept it? ------------------------------ Laszlo M ------------------------------ Re: Export field list from Quickbase Hi Amy, Ngan Dinh, Maybe this helps: Go to Settings\Fields of your table of interest. Set to your needs, then just drag over the field list with your mouse from the upper left corner to the bottom right... Browser shall scroll if you dragging past the lower screen limit. Ctl-C and open Excel. Paste as text, adjust the first row. Hope this helps! Regards, L ------------------------------ Laszlo M ------------------------------ Re: I experience hour long delays in refresh for formula-user fields dependent of freshly provisioned users! Thank You for sharing your experience here Mark and Austin! I think I can live with this, just needed a confirmation of this happening to others as well, so I may not be the only one... Austin, this is exactly what I am doing, thank you for the idea! Thx! ------------------------------ Laszlo M ------------------------------ I experience hour long delays in refresh for formula-user fields dependent of freshly provisioned users!Hi All! New users happen to come to my app in form of email address list. Some emails are already users of my app, some are not, UserToEmail function makes the distinguishing. Now for emails not yet users I use API_ProvisionUser to establish a new user in the appropriate role, also I would like to immediately assign the new usersto their tasks. I mean users as established QB users, not just any text labels! To this end I decide if the email address is a user with this formula checkbox: If(ToText(ToUser([Technician Email]))="",false, true) Problem is when my pipeline finishes provisioning the new users, nothing seems to happen to my checkbox, in fact it takes hours to react!!! Funny thing is that after provisioning the new users immediately appear in the user list and are also available in the user pickers. Just the depending user-formulae are lazy as hell. However I tried to set the report caching the problem still persists! Questions: - am I missing here something, doing something wrongly? - anybody has similar experience with user functions? ...if all this is real: any ideas to solve this delay problem or have a workaround would make me happy! Thank You! ------------------------------ Laszlo M ------------------------------ Re: Pipeline to write non-English characters: is it possible without realm UTF-8 setting ?Thx Laura! What about the realm set to UTF-8 enforcing? Wouldn't that work either? ...also, I am not surprised, but I am interested in any possible workaround! ------------------------------ Laszlo M ------------------------------ Pipeline to write non-English characters: is it possible without realm UTF-8 setting ? I have a pipeline which copies address fields from one app to another. My - limited - experience shows that pipelines indeed can not write non-english caracters, only read them. So if in an address field contains any accented characters, it will not be copied, the old value stays in the destination. Now quickbase clearly states that pipelines can only read not write these characters if only my app and not the realm forces utf-8 (which is my case): About UTF-8 Support Is there some Jinja function which can be of help here ? Or how to make a pipeline change its mind to handle the non-english characters as a workaround to the realm not-set to UTF-8 enforcing? Thank You! ------------------------------ Laszlo M ------------------------------ Re: To capture an XML response from an API in PipelinesThank You Phillip! That opened the door and now I'm down the rabbit hole into JSON parsing and JINJA filters.... I asked for it, I know... Thank you so much, just that little piece was what I needed! ------------------------------ Laszlo M ------------------------------ Re: Correct format for Address in Pipelines, if field name has a spaceThank's for posting this! I had real trouble finding my workaround: replacing spaces with underscores in the original field label. Reading through this thread I understand the problem is Pipelines is not putting together a correct JINJA syntax just assumes the field labels do not contain spaces... In fact I have found this in the QB documentation: Example - workaround for address fields with spaces Address fields in Quickbase using the ‘parent’ label have the safe field name applied when creating the keys for address sub-fields in the pipelines schema. This means that any time a you try to access a sub-field of an address field that contains spaces in the name, thejinjaexpressions become invalid due to the spaces, or may get interpreted as ajinjaexpression that differs from the user’s intent. To work with this behavior in ajinjaexpression, we suggest you follow these guidelines: Properties of objects injinjacan be accessed either with the formats of {{a.my_field}} or through {{a['my_field']}} , which supports spaces in the property name. Well, Mike, THX anyway! ------------------------------ Laszlo M ------------------------------To capture an XML response from an API in PipelinesHi All, I would like to use a simple Quickbase API (API_ProvisionUser) in a Pipeline and use the user id included in the response in my subsequent Pipeline steps. Response promised in the API docs: <?xml version="1.0" ?> <qdbapi> <action>api_provisionuser</action> <errcode>0</errcode> <errtext>No error</errtext> <userid>112248.5nzg</userid> </qdbapi> Is there a way I can parametrize a Quickbase channel API request to get the XML response? Suppose getting my stuff out of the XML text would be somehow possible, but how can I capture the API response? Seems Pipelines does not offer any available new field after establishing this API request step. Or I am doing something wrong... Thank You! ------------------------------ Laszlo M ------------------------------ Re: Thumbnail pictures refreshing slowlyFabulous! Thank You very much Mark! László ------------------------------ Laszlo M ------------------------------