Skip to main content

I read through almost all Formulas documentation and still cannot find an example for what I'm trying to do.  To make it as simple as possible here is an example.  



I have 2 TextBoxes on a page.  



Textbox1 and Textbox2



I want to make Textbox2 show a property value (name id text value anything) from Textbox1.  



If I change Textbox1 text to "changed twice" I want to see that value/text in Textbox2.  



What formula would allow me to see properties in Textbox1?  Everything I have tried has resulted in #ERROR!



Thanks

@william j


for Textbox1 create a data field (aka property) and for its value put the following


=LABEL(this)


it will display the label of Textbox1 it will look something like this: cEx3kxzL~1CZ


then create as many properties as you want id text whatever. Name the properties properly because you'll need to call them later


--


then for Textbox2 create a data field or property and put the following formula:


=FINDSHAPEBYLABEL("cEx3kxzL~1CZ")."id"


as you can see the second formula goes as follows 


=FINDSHAPEBYLABEL("block label")."property name"


and it will call back any property value from Textbox1 into Textbox2


--


by the way I couldn't find the second formula anywhere in the documentation I think Lucid needs to do better in that regard I guessed it by typing "label" or "find" or "get" in the formula field and see what the results are and trying them


--


Hope this helps


This is perfect.  


Thanks!


Cheers!


Hi William and Jumana 


Thank you for your responses and for your feedback! I wanted to share an additional method in case you or anyone else might find it helpful. Here are the steps to have a property or value from one shape reflected in another shape:


In Textbox 1:



  1. Input the property and value

  2. Identify the label for Textbox1:



  • Create a new data field.

  • Retrieve the auto-generated label for your shape using the formula: =label(this)

  • In the data toolbox: copy the auto-generated label for Textbox1



In Textbox 2:



  1. Create a new data field.

  2. Name the property

  3. Input the formula =#”(paste the auto-generated label for Textbox1 here)”.”(paste the title of the property from Textbox1 that you want reflected here)”



*Tip: to make any property or value visible in the shape click the T+ symbol on the right in the data toolbar


I hope this is helpful! Let me know if you have any additional questions.


Hi! I’m Micah from Lucid’s community team. 👋 Jumping in here to share about Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!

 


Reply