[Feature] Use formula column as primary value

[tlonic]

Recommending Features

Need for this feature
Allows one to create a title for every row which combines elements from multiple fields. Especially helpful since the primary view determines what shows up in linked records.

Is your feature request related to a problem? Please describe.
You cannot set a formula column as a primary view

Describe the solution you'd like
Ability to set formula column as a primary view

[rallisf1]

In 0.91.7 for some reason it automatically uses the formula field of the linked table as the primary value, although you can't manually set it. See #2316

[Curiuke]

I´d love this feature too :)

[paullaffitte]

Definitely a must have!

Here is my case: I import my bank statements in nocodb for my personal accounting. My columns are: accounting_date, label, reference, credit and debit. So for example I can have a record like this:

{
  "accounting_date": "2022-09-03",
  "label": "PRLV SEPA XXXXXX",
  "reference": "WJCO239",
  "debit": 42.42,
  "credit": 0,
}

For some reason, my bank sometimes use the same reference for several transactions, for recurring transaction, the label isn't very helpful for identification and the date is obviously not a candidate.

I would like to use as primary value a formula including at least the date and the total value of the transaction, example: [2022-09-03] 42.42. This way it would be much easier to link a transaction to a budget for instance.

[ColinMaudry]

@tlonic I guess you mean primary value and not view, right?

[tlonic]

Yes, that's right, my mistake

…

On Thu, Nov 3, 2022, 10:41 AM Colin Maudry ***@***.***> wrote: @tlonic <https://github.com/tlonic> I guess you mean primary *value* and not view, right? — Reply to this email directly, view it on GitHub <#1809 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AASIWVYJMM7EF35S6MNDLFDWGPMJTANCNFSM5T54J3OA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pareshpandit]

+1 for this feature request.

This gives one the flexibility to concatenate one or two fields in a (hidden) column, and use it as a sort of "data-label" in related table entries, such that the relation/origin can be more readily identified. _/|_ :)

[folk-connect]

+1

[dstala]

available now in https://github.com/nocodb/nocodb/releases/tag/0.105.0