I’ve been trying to show a quote noted in database as theirQuote with the person’s name as theirName.
database is something like this…
[
{
“name”: “projects/app-55c5d/databases/(default)/documents/Quotes/17JzYVW5riClsR87D1cA”,
“fields”: {
“theirQuote”: {
“stringValue”: “Don’t wait. The time will never be just right.”
},
“theirName”: {
“stringValue”: “Napoleon Hill”
}
},
“createTime”: “2021-04-05T13:07:05.680545Z”,
“updateTime”: “2021-04-06T13:08:10.529866Z”
},
{
“name”: “projects/growmi-55c5b/databases/(default)/documents/Quotes/17rDA8kI1B1Kk14rdBH9”,
“fields”: {
“theirQuote”: {
“stringValue”: “From error to error one discovers the entire truth.”
},
“theirName”: {
“stringValue”: “Sigmund Freud”
etc.
My setup is as follows:
when page mounted, set page variable randomInteger to RANDOM_INTEGER_BETWEEN(0, 51) which will serve as the index I’m calling for the next step
I then have paragraph content set to the formula
It looks like the property theirQuote is within the property fields, but your current formula acts as though theirQuote is a top-level property. To get that property from within another property, your formula would need to be something like this:
