Tobias Kern Posted February 29 Share Posted February 29 (edited) 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 1 Quote Link to comment
Pat Stanford Posted February 29 Share Posted February 29 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. 1 Quote Link to comment
Tobias Kern Posted February 29 Author Share Posted February 29 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 1 Quote Link to comment
Haoran Yang Posted March 1 Share Posted March 1 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.... 1 Quote Link to comment
Pat Stanford Posted March 1 Share Posted March 1 I think the other thread has a worksheet script that returns all the popup values. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.