{"id":2816,"date":"2022-04-19T07:38:42","date_gmt":"2022-04-19T12:38:42","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=2816"},"modified":"2022-04-19T07:59:52","modified_gmt":"2022-04-19T12:59:52","slug":"displaying-order-details-in-mobile-client-app","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/","title":{"rendered":"Displaying order details in mobile client app"},"content":{"rendered":"\n

If your low code<\/a> database includes client orders, a delivery agent may need to review order details using a mobile client app<\/a>.
The simplest way to display details would be accessing the database via a browser, however, if a delivery agent should be able to confirm orders using a mobile action, you would need to generate a document including order details<\/p>\n\n\n\n

1. Generated Document including order details<\/h3>\n\n\n\n

Firstly, generate a document<\/a> you need. This document should include an order data along with related details<\/a>, such as ordered items.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

2. Formula-URL column<\/h3>\n\n\n\n

In the next step, you would need a Formula-URL<\/a> column to build a URL referring to the created “Order Document” comprising ordered items.
The URL formula should include the record Id numbers, therefore first of all you need to create a Formula-Text column keeping the RecordId()<\/a> function.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Then you can create the Formula-URL column comprising the following formula<\/p>\n\n\n\n

\"https:\/\/www.teamdesk.net\/secure\/api\/v2\/83590\/02F639FFF7C24C509D67468A2DDF6529\/Client%20Order\/Order%20Document\/document?Id=\" & [Record ID formula]<\/code><\/pre>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Please note that the URL consists of the following elements:<\/p>\n\n\n\n
URL Element<\/td>Description<\/td><\/tr>
83590<\/td>This is a database id number that is visible in database URL, for example:
https:\/\/www.teamdesk.net\/secure\/db\/83590\/overview.aspx?t=939103 
Your database will have a different number.<\/td><\/tr>
02F639FFF7C24C509D67468A2DDF6529<\/td>This is the REST API<\/a> authorization token generated by the system. In your database you will use a different token.<\/td><\/tr>
Client%20Order<\/td>This is the “Client Order” singular name<\/a> of the table “Client Orders”, please note that spaces are replaced by “%20”.<\/td><\/tr>
Order%20Document<\/td>This is the document name<\/a>. In this example the document name is “Document A”. So, the space is replaced by “%20”.<\/td><\/tr>
[Record ID formula]<\/td>This is the name of the formula-text column described above.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
3. Custom button with actions<\/h3>\n\n\n\n
Now you can configure a custom button<\/a> with actions. The button will generate a document. Let\u2019s name the button \u201cCreate Document & Send Order\u201d.
This button will generate a document file and will insert it into the “Document File Attachment” column. Moreover, it will activate the Mobile Record Update<\/a> action for a corresponding user, for instance for a delivery agent.
As the result, the agent will be able to review the “Order Document” keeping ordered items, and then check the “Completed” checkbox when the order is completed.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
4. Save document as a file attachment \u2013 Update Record action<\/h3>\n\n\n\n
A Record Update action<\/a> can use the created Formula-URL column to insert a generated document into the “Document File-Attachment” column of the file-attachment<\/a> type.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
5. Sending Order details to a mobile client app via a Mobile action.<\/h3>\n\n\n\n
To send a generated document as a file attachment to a user mobile phone, you need to create a Mobile record update action.<\/a><\/p>\n\n\n\n
\"Mobile<\/a><\/figure>\n\n\n\n
6. ReadOnly option for the Document File Attachment column<\/h3>\n\n\n\n
To display the file attachment in the Mobile Update Record action, the Readonly option must be set for the “Document File Attachment” column, otherwise the generated document attachment will not be visible in the mobile update record action. Using the Form Behavior<\/a> settings, you can activate the “Readonly” option for the “Document File Attachment” column on the Edit form. Furthermore, other columns, such as “Contact” and “Delivery Date” columns\/fields can be set as Readonly as well. You can adjust this form behavior only for the “Delivery Agent” role.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
7. How the setup works<\/h2>\n\n\n\n
When an Order record with ordered items is created, you can click on the \u201cCreate Document & Send Order\u201d custom button.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
As the result, the document attachment will be generated, and the Mobile Update record action will be sent to an assigned user.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
A user, who is a delivery agent, can open an “Order Document” attachment to review the ordered items.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
When the Order is delivered, this delivery agent can check the “Completed” checkbox.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"
How to save generated document as a file attachment and how to show this document in a mobile action.<\/p>\n","protected":false},"author":3,"featured_media":2854,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[257,216,141,134,282],"class_list":["post-2816","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tricks","tag-generated-document","tag-low-code-2","tag-lowcode-database","tag-mobile-app","tag-order-detilas"],"yoast_head":"\nDisplaying order details in mobile client app - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Displaying order details in mobile client app - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-19T12:38:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-19T12:59:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2360\" \/>\n\t<meta property=\"og:image:height\" content=\"1310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mila\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mila\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/\"},\"author\":{\"name\":\"Mila\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"headline\":\"Displaying order details in mobile client app\",\"datePublished\":\"2022-04-19T12:38:42+00:00\",\"dateModified\":\"2022-04-19T12:59:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/\"},\"wordCount\":615,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Order-Details.png\",\"keywords\":[\"generated document\",\"low code\",\"lowcode database\",\"mobile app\",\"order detilas\"],\"articleSection\":[\"Tips & Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/\",\"name\":\"Displaying order details in mobile client app - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Order-Details.png\",\"datePublished\":\"2022-04-19T12:38:42+00:00\",\"dateModified\":\"2022-04-19T12:59:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"description\":\"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Order-Details.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/Order-Details.png\",\"width\":2360,\"height\":1310,\"caption\":\"order details\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/displaying-order-details-in-mobile-client-app\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Displaying order details in mobile client app\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\",\"name\":\"Mila\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"caption\":\"Mila\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/mila\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Displaying order details in mobile client app - TeamDesk Blog","description":"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/","og_locale":"en_US","og_type":"article","og_title":"Displaying order details in mobile client app - TeamDesk Blog","og_description":"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/","og_site_name":"TeamDesk Blog","article_published_time":"2022-04-19T12:38:42+00:00","article_modified_time":"2022-04-19T12:59:52+00:00","og_image":[{"width":2360,"height":1310,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png","type":"image\/png"}],"author":"Mila","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mila","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/"},"author":{"name":"Mila","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"headline":"Displaying order details in mobile client app","datePublished":"2022-04-19T12:38:42+00:00","dateModified":"2022-04-19T12:59:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/"},"wordCount":615,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png","keywords":["generated document","low code","lowcode database","mobile app","order detilas"],"articleSection":["Tips & Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/","name":"Displaying order details in mobile client app - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png","datePublished":"2022-04-19T12:38:42+00:00","dateModified":"2022-04-19T12:59:52+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"description":"If your low code database includes client orders, a delivery agent user may need to review order details using a mobile client app.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2022\/04\/Order-Details.png","width":2360,"height":1310,"caption":"order details"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/displaying-order-details-in-mobile-client-app\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Displaying order details in mobile client app"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e","name":"Mila","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","caption":"Mila"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/mila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=2816"}],"version-history":[{"count":22,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions"}],"predecessor-version":[{"id":2858,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions\/2858"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/2854"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=2816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=2816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=2816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}