Help: Worksheet formula: If there is a certain value in a cell, then show the content of a database field with a certain value in an other cell.

[Tobias Kern]

Hi VW-Forum,

 

I'm kind of stumped and need help with a formula.

 

Idea:
If there is a certain value in a Spreadsheet cell, then show the content of a database field with a certain value in an other Spreadsheet cell.

Please find attached the test file with a further description.

 

Greetings and thanks for help

Tobi

24-02-29 Test.vwx

Edited February 29 by Tobias Kern

[Pat Stanford]

Do you want the value of the field for a specific object? Or do you want the default value of the field for that record?

 

If you were working in Database cells, then the object would be already defined and all you need to do is display the value from the attached record.

 

But since you are in a Speadsheet cell you will also need to define which object to use the record from.

[Tobias Kern]

Hi Pat,

 

greetings.

 

The idea was to have direct access to the database and the database content

(Pop-Up list content) itself without having to select a specific object.

 

With =Formatfield() you can access the default value of the pop-up list, but not the rest.

 

Greetings

Tobi

[Haoran Yang]

Hi

I just got the same problem, I just want to access the true txt from my data tag. and i just got no solution....

[Pat Stanford]

I think the other thread has a worksheet script that returns all the popup values.