Answer

Reference Properties in One Object and Display On Another Object

Forum|Forum|3 years ago
October 25, 2022
5 replies
97 views

William J

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

Best answer by Jumana J

@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

Jumana J
Answer
Forum|Forum|3 years ago
October 25, 2022

@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

Hope this helps

William J
Author
Forum|Forum|3 years ago
October 25, 2022

This is perfect.

Thanks!

Jumana J
Forum|Forum|3 years ago
October 25, 2022

Cheers!

+23

Addie
Forum|Forum|3 years ago
October 25, 2022

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:

Input the property and value
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:

Create a new data field.
Name the property
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.

Addie

+20

Micah
Lucid community team
Forum|Forum|1 year ago
May 6, 2024

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!

In Textbox 1:

In Textbox 2:

Create an account in the community

Log in to the community

Scanning file for viruses.

This file cannot be downloaded