# Tulip Office Hours 12/10/2020 **URL:** \ **Category:** Announcements\ **Tags:** office-hours\ **Created:** [December 9, 2020, 8:55pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408 "2020-12-09T20:55:27Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [December 9, 2020, 8:55pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/1 "2020-12-09T20:55:28Z")
hello all!! I wanted to share that we’ll be hosting our next Tulip Office Hours 2020-12-10T16:00:00Z → 2020-12-10T17:00:00Z. if you have questions ahead of time, we ask that you add them as comments here below and we’ll address them in the order in which they were received. If you don’t have specific questions, feel free to join the session and view how other users are building apps for their shop floor!! please complete this form if you’d like to get invited to the Office Hours: https://docs.google.com/forms/d/e/1FAIpQLScPetXYCrkFrvcLS80YKdxIRTjQUei7_n0GDGLAaBmqz7m_1Q/viewform?embedded=true we look forward to seeing you there! gio ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [December 10, 2020, 5:32pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/2 "2020-12-10T17:32:47Z")
thanks to all who joined today’s Office Hours, here is the recording for those who missed it: [![](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/132d8145564d441ee98b6c6a1dbbc0a703904046.jpeg "Tulip Office Hours 12/10/2020") ](https://www.youtube.com/watch?v=P_HojKFebqU) this is what was covered: 0:00 Displaying ZPL in Apps prior to printing 0:08 Date Validation 0:16 Email Validation and Displaying Errors and Messages (and success Messages) 0:20 Using RegEx to validate inputs 0:25 Verifying Multiselect Widget has been entered 0:30 Vision 0:35 Linking Table Records ---
**Author:** ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)\ **Post date:** [December 10, 2020, 6:25pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/3 "2020-12-10T18:25:24Z")
Hello, Can be possible to have in text file syntax for SQL function for Zebra? I fail to do this Youri **Youri Regnaud** Business Capabilities Manager Business process integrator Manufacturing Cartier SA Rue André-de-Garrini 1217 Meyrin - Suisse Tel +41 79 305 55 26 Skype +41 79 305 55 26 [youri.regnaud@cartier.com](mailto:emailadresse@cartier.com) ![]() Pensez environnement N’imprimez ce mail que si nécessaire ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [December 10, 2020, 6:30pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/4 "2020-12-10T18:30:27Z")
hello @youri.regnaud. just to confirm, is this what you’re looking for?? `select concat('http://api.labelary.com/v1/printers/8dpmm/labels/4x6/0/', replace(replace(replace(replace(replace(replace(replace($zpl_code$, ' ', '%20'), '^', '%5E'), ' ', '%20'),'#','%23'),'[','%5B'),'>','%3E'), CHR(10), '%20')) as "label"` input: `zpl_code` output: `label` ![Screen Shot 2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/e8fd93a106b06efafc48ab570d4f35e53e630bf6.jpeg) ---
**Author:** ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)\ **Post date:** [December 10, 2020, 9:18pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/5 "2020-12-10T21:18:57Z")
Thanks you, I still have an issue, I don’t really understand why? Do you see something? (no production instance) [https://cartier-staging.tulip.co/connector/vX3guC862zN7g7Yrt/function/aYt9nJWLp7WLc7YST](https://cartier-staging.tulip.co/connector/vX3guC862zN7g7Yrt/function/aYt9nJWLp7WLc7YST) Youri ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [December 10, 2020, 9:27pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/6 "2020-12-10T21:27:02Z")
no problem @youri.regnaud. it seems to be working when testing on my end: ![Screen Shot 1](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/c64e662ce92b5c30f1538c838340fe00aa4c1560.png) result: ![Screen Shot 2](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/4317cf869413f46e8193f059b87427e3273820db.jpeg) what is the issue you’re experiencing?? ---
**Author:** ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)\ **Post date:** [December 10, 2020, 9:39pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/7 "2020-12-10T21:39:55Z")
No display in my app [https://cartier-staging.tulip.co/process/TNmydejhw3hnBnYCM/steps](https://cartier-staging.tulip.co/process/TNmydejhw3hnBnYCM/steps) Youri ---
**Author:** ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)\ **Post date:** [December 10, 2020, 9:41pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/8 "2020-12-10T21:41:38Z")
Find issue, Display doesn’t work in « developer mode” but ok in Player Test mode Youri ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [December 10, 2020, 9:46pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/9 "2020-12-10T21:46:27Z")
OK, thanks for the update @youri.regnaud!! I have submitted a ticket with our Engineering team to investigate what is happening while in Dev mode, we’ll keep you posted with updates. ---
**Author:** ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)\ **Post date:** [December 10, 2020, 9:46pm UTC](https://community.tulip.co/t/tulip-office-hours-12-10-2020/1408/10 "2020-12-10T21:46:29Z")
Tulip can be a real good alternative to solution as NiceLabel cloud for supplier printing : ![image001.jpg](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/1X/6ffcb441ebd200fd7ca0fda00b6ef916a6e412e5.jpeg) [https://www.nicelabel.com/designer-and-desktop-solutions/print](https://www.nicelabel.com/designer-and-desktop-solutions/print) Youri