Help

Help with writing a Formula

Topic Labels: Community Formulas
Solved
Jump to Solution
1087 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tom_David
6 - Interface Innovator
6 - Interface Innovator

I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.

IF
First 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee Paid} is Checked, insert the amount in {2023 Maint. Fees} field.

Association Table
{Unit & Week} is not the primary field
{2023 Fee Paid} is a Checkbox

Maint Fees Table
{Unit Name}
{2023 Maint. Fees}

2 Solutions

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hm, seems like something you need to use a linked field with a conditional lookup for instead of a formula.  Could you provide some screenshots of your tables please?

See Solution in Thread

Tom_David
6 - Interface Innovator
6 - Interface Innovator

Thanks, Adam. "...a linked field with a conditional lookup" was my second thought. Let me play around with that and if I'm still stuck I'll re-post.

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hm, seems like something you need to use a linked field with a conditional lookup for instead of a formula.  Could you provide some screenshots of your tables please?

Tom_David
6 - Interface Innovator
6 - Interface Innovator

Thanks, Adam. "...a linked field with a conditional lookup" was my second thought. Let me play around with that and if I'm still stuck I'll re-post.