Jump to content
  • 0

Create a relationship based on the value in a formula field?




I'm just getting started with evaluating Caspio,  to potentially use in a project for a client of ours. I'm using some data of theirs to play around with, and it makes sense (to my brain at least, exposed many years ago to FileMaker), to create a formula field, and then use that calculated value as the key to a related table, but Caspio doesn't want to let me use the formula field in a relationship definition.

What's the Caspio way of doing what I'd like to accomplish?



Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @DavidBoroditsky :) I think that is not possible. I also found another forum thread discussing about using a formula field for relationships:

Have you considered a different approach to create this unique value besides formula field? Maybe through triggered action or calculated fields (if you will populate the table using submissions). For your reference, here's the list of compatible data types for creating relationships which can be found in this article:

Data Types Relationship Compatibility
Integer Integer, Autonumber
Autonumber Autonumber, Integer
Number Number
Currency Currency
Text (255) Text (255), Prefixed Autonumber, Random ID, GUID
Prefixed Autonumber Prefixed Autonumber, Text (255)
Random ID Random ID, Text (255)
GUID GUID, Text (255)
Date/Time Date/Time, Timestamp
Timestamp Timestamp, Date/Time




Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...