I’d like to create a formula that links a field from an Outcome to a Proposal through a Project. [Outcome] One ↔ One [Project] One ↔ Many [Proposals] This is relatively simple: I can create a formula inside of Proposals Project.Outcome.[Over vs Under Resourced] However, I’d only like this inform…

It’s an interesting use case. I don’t think it’s possible with formulate. However, you can kinda hack it. Use text field instead of formula. Create rule for update of status. Filter to only approved On Update of Status to Approved set the text field “[Over vs Under Resourced]” using formula Pro…

This has been requested before! There is an ugly way to hack it, which is to filter for an entity that will never be found: Project.Outcome.Filter(Name = "!LOL!").Sort().First()

[image] Matt_Blais: Project.Outcome.Filter(Name = “!LOL!”).Sort().First() That is brilliant but alas it doesn’t seem to like it: [Screen Shot 2023-03-23 at 10.08.05 AM] Perhaps you cannot filter on a one-to-one relation?

If you want to return a specific field like [Client Temperature] from the Formula, you must add that field to the bogus search result as well, because all potential (conditional) Formula results must return the same data type: Project.Outcome.Filter(Name = “!LOL!”).Sort().First().[Client Temperatur…

[image] Matt_Blais: Project.Outcome.Filter(Name = “!LOL!”).Sort().First().[Client Temperature] It seems it’s the filter method itself it has a problem with [Screen Shot 2023-03-23 at 10.45.38 AM]

Yep, you can’t filter on a to-one relation. AFAIK there’s no easy way to do this using field formulas only :disappointed:

Some day :roll_eyes: Related: [image] Allow to return an empty value from a formula Ideas & Features Related:

Return "no-entity" from a formula

Get Help

Matt_Blais March 23, 2023, 6:02pm 8

Some day

Related:

Topic		Replies	Views
Allow to return an empty value from a formula Ideas & Features formulas	26	1398	March 10, 2026
If condition: how to return nothing when the returned type is an entity? Get Help formulas	4	482	January 27, 2022
Formula 'Generate using AI' keeps on using 'null' Bugs & Issues automations , formulas , ai	1	54	August 1, 2025
Setting dropdown value via formula Get Help automations , formulas	2	316	December 18, 2023
"Enter text" appears in Formula field [FIXED] Bugs & Issues formulas	2	331	November 15, 2022

Return "no-entity" from a formula

Related topics