文档生成器可填充PDF -符号字段

SueinSpain
SueinSpain ✭✭✭✭✭✭

大家好!

我在adobeacrobatpro中创建了可填充的PDF

我已经使用文档构建器映射了我的smartsheet,它工作得非常出色(yippee).........

......但我在Smartsheet中使用了符号来表示RAG状态(红色、琥珀色(或智能表术语中的黄色)、绿色)。遗憾的是,这些词给人的印象是单词,而不是颜色或符号。


有人知道我如何在可填充的PDF中把这些变回颜色吗?传递其他符号也很有用——例如,我们使用饼符号表示% complete,但它会显示为空、满、四分之一、一半等。

谢谢大家的期待

如内容价值

image.png

PDF格式的文档值

image.png


标签:

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @SueinSpain

    我希望你一切安好!

    我不确定它是否被支持,所以也许您可以使用下面的方法转换它们。

    你可以通过使用UNICHAR、CHAR或Emojis来使用其他符号。

    更多信息:

    保罗·纽康姆汇集了大量的资源

    工作/帮助吗?

    我希望这能有所帮助!

    注意安全,祝你有一个美好的一周!

    最好的

    她名叫Stara|工作流顾问/ CEO @工作大胆

    我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案.这将使别人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    她名叫Stara|工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时联系我有关Smartsheet的帮助,集成,一般的工作流程建议,或其他完全的东西。

  • SueinSpain
    SueinSpain ✭✭✭✭✭✭

    谢谢你的回复并一如既往地支持Andree -我会调查所有这些,因为我只是不知道从哪里开始。

    保持安全和健康

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @SueinSpain

    太好了!

    你太客气了!

    记住!我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案.这将使别人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    她名叫Stara|工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时联系我有关Smartsheet的帮助,集成,一般的工作流程建议,或其他完全的东西。

  • 你好,

    你找到解决方法了吗?因为我也在尝试找到同样的方法,但我不确定上述方法是否可以作为替代方案。

    谢谢,

  • SueinSpain
    SueinSpain ✭✭✭✭✭✭

    嗨,珍,

    我太忙了,还没有尝试过建议的解决方案。不确定这就是答案,但安德里太好了。

    这个想法是将单词“红色”翻译成一个符号或特殊字符,然后出现在pdf上。

    所以恐怕还在我的任务清单上

    最贴心的问候

  • SueinSpain
    SueinSpain ✭✭✭✭✭✭

    你好,

    最后我回过头来看看这个,但它并没有真正解决我的问题。

    在我的智能表中,我有一个具有红色、黄色、绿色等值的符号字段。

    image.png
    image.png

    这是用来指示使用它作为RAG状态/视觉辅助的关卡。

    然而,字段的实际内容(在幕后可以说)是单词“黄色”

    image.png

    因此,当我使用Generate Documents函数将它传递给一个可填充/可写的PDF时

    image.png

    它实际上是通过“黄色”这个词,而不是圆形的黄点或任何突出显示的东西。参见下面生成的PDF文档

    image.png


    理想情况下,我希望以某种方式突出显示单词或显示一个符号,该符号在文档中以与智能表相同的方式着色,因为单词只是没有相同的影响。

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @SueinSpain

    你测试过Emoji选项了吗?

    Smartsheet专家顾问和合作伙伴

    她名叫Stara|工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时联系我有关Smartsheet的帮助,集成,一般的工作流程建议,或其他完全的东西。

  • 我试过表情包,结果是空白。我甚至尝试使用格式让它工作,看起来格式要么被删除,要么将工作,然后格式被用于每一个其他实例的生成文档。

    我试着联系技术支持,在一个电话没有解决问题后,我再也没有收到他们的消息。

  • 我试过这个表情符号UNICHAR,当然还有Smartsheet上已经有的符号。除了在PDF中显示一个普通的字母或数字字符外,我无法找到任何方法。我知道最近更新的符号,所以希望这更新以及。有人找到其他路线了吗?

Click on the \"Run once\" and change it to custom then weekly.<\/p>

Also you may need a condition if I'm not mistaken. Maybe something easy like if a column is not blank type of thing. Pick a column that will never be blank.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-11 12:57:19","updateUser":{"userID":134933,"name":"Taylar Rodgers","url":"https:\/\/community.smartsheet.com\/profile\/Taylar%20Rodgers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nNfc_347Db4!hMHTIRzoLX4!9v0U4w3sDeJ","dateLastActive":"2022-10-11T12:57:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":96245,"type":"question","name":"How do you create new Programs within Control Centre?","excerpt":"Hopefully a really simple question... I have the PMO Program in Control Centre and that's working well with blueprints etc, however I want to setup another program for Finance and I can't see how or where to do this?","categoryID":343,"dateInserted":"2022-10-05T11:05:48+00:00","dateUpdated":"2022-10-06T12:08:23+00:00","dateLastComment":"2022-10-11T12:35:17+00:00","insertUserID":136915,"insertUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":136915,"lastUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3330461465,"url":"https:\/\/community.smartsheet.com\/discussion\/96245\/how-do-you-create-new-programs-within-control-centre","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96245\/how-do-you-create-new-programs-within-control-centre","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":96245,"commentID":346737,"name":"Re: How do you create new Programs within Control Centre?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346737#Comment_346737","dateInserted":"2022-10-11T12:35:17+00:00","insertUserID":136915,"insertUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-11T12:35:21+00:00","dateAnswered":"2022-10-11T12:35:17+00:00","acceptedAnswers":[{"commentID":346737,"body":"

Hi All, I needed to ask the Customer Success \/ Support team to set this up for me as it looks like I couldn't do this on my own.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-11 12:35:21","updateUser":{"userID":136915,"name":"Matthew LeMasonry","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20LeMasonry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-11T12:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":466,"urlcode":"control-center","name":"Control Center"}]},{"discussionID":96357,"type":"question","name":"Is there a way to tell what sheet a form is connected to?","excerpt":"I've been sent a form to potentially edit but the requestor does not know what sheet it is connected to. Is there a way to figure out what sheet a form is connected to if you do not already know? I'm asking around but got curious if there was a way to figure out just using Smartsheet. Thank you!","categoryID":321,"dateInserted":"2022-10-07T15:57:26+00:00","dateUpdated":null,"dateLastComment":"2022-10-07T16:32:17+00:00","insertUserID":153311,"insertUser":{"userID":153311,"name":"meb_0101","url":"https:\/\/community.smartsheet.com\/profile\/meb_0101","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-10T20:35:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-11T15:57:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3330320383,"url":"https:\/\/community.smartsheet.com\/discussion\/96357\/is-there-a-way-to-tell-what-sheet-a-form-is-connected-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96357\/is-there-a-way-to-tell-what-sheet-a-form-is-connected-to","format":"Rich","tagIDs":[204,228],"lastPost":{"discussionID":96357,"commentID":346499,"name":"Re: Is there a way to tell what sheet a form is connected to?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346499#Comment_346499","dateInserted":"2022-10-07T16:32:17+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-11T15:57:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-07T16:01:57+00:00","dateAnswered":"2022-10-07T16:00:01+00:00","acceptedAnswers":[{"commentID":346487,"body":"

Hi @meb_0101<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!<\/p>

Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-07 16:01:57","updateUser":{"userID":153311,"name":"meb_0101","url":"https:\/\/community.smartsheet.com\/profile\/meb_0101","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-10T20:35:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">