This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
This seems like a straightforward question and a simple fix -- can we get the "Unique" and "Percent Unique" options for the Linked Records field type when we click on the column summary??These two summary options are available for single select, mult...
Hi all, I’m trying to create an automation that will update a linked record field (which sometimes starts empty, sometimes starts with records already in it) based on whether a lookup field is not empty.
The original data I am using is sensitive so I...
I frequently use the formula IF((FIND)) formula to create indicator columns with 1s and 0s or emojis.
In my latest project, however, it has not been working out as I want:
The above is a screenshot of a Grid View of form results.
The field “BACKEND_...
Hello,
I am trying to create a field that concatenates two rollup fields that have the array(unique) formula in each of them. But the concatenated result eliminates the comma.
You can see in the 10th row, the comma between “Refugee Support” and “Wat...
Hello,
I’m trying to summarize information in a Linked Record field type collected through Forms in which respondents can select multiple linked records. We invite respondents to select their Subject Area Expertise, options provided are categories fr...
@cntorres I've been looking for a week for a way to filter and group by Calendar Year and this solved the problem!!!! It allows me to set up dashboards for some teams in my organization that won't require them to keep updating filters as the years pa...
Hi Laura,I think this might be a temporary problem, because I had an interface with charts using lookup fields that worked fine for a whole month, and just this week they weren't displaying properly. I explained more in my reply here (came to the Com...
Hi choldgraf.This happened to my team's interfaces this week, so I hope it is a temporary issue. As originally designed, the interface we have displayed state (location) of respondents to our form:Field type was Linked Record to a table where each St...
Adam_TheTimeSavingCo:
Hmm! Sorry, I don’t understand this bit, the formula would be longer but would still work fine. What’s the problem that arises from having many restaurants?
I may very well be misinterpreting your suggestion or am unfamil...
That would be handy if I only had three Restaurants, but I have more than a dozen!
But your response did inspire me to create two lookup fields of Restaurant names in the Order table’s “part of menu” or “individual dish” fields, and then create two R...
