Pamela_Giles - profile

Pamela_Giles · Dec 30, 2023

TLDR: I'm not able to upgrade to a Business account, and when I go to my workspace, it says it does not belong to my company. I am the sole billable collaborator in that workspace, and I'm listed there as Owner.---I'm a consultant. A year ago, I set ...

Pamela_Giles · Aug 19, 2023

I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these st...

Pamela_Giles · Apr 29, 2020

This seems like ridiculously easy formula to write, but I’m stymied. IF({Paid} ≥ {120%}, ({Paid} - FMV),0) If the person Paid more than 120% (120% is a column calculating 120% of the Fair Market Value), then the value of their tax receipt is the amou...

Pamela_Giles · Aug 19, 2023

ChatGPT knew how to do it: UPPER(REPLACE({PostCode}, 4, 0, " "))

Pamela_Giles · Apr 29, 2020

Thank you, @ScottWorld. I was not an expert at Filemaker Pro either, but I did love it and had managed to make formulas work. That probably IS why I thought ≥ would work! Filemaker was very expensive to upgrade, though, and it was hard for my busines...

Pamela_Giles · Apr 29, 2020

I put the spaces in because some of the examples in the help seemed to have them. The extra { }s went in in desperation. It’s definitely the ≥ symbol that was the problem. I never would have figured that out on my own. Thanks again.

Pamela_Giles · Apr 29, 2020

My gosh! That works!!! I guess I could nest to include the = FMV as a separate line. Thank you.

Pamela_Giles · Apr 29, 2020

It gives me error message “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.”

User Statistics

User Activity

Unable to Upgrade to Business

Combine two formulas to format postal codes

Help with basic IF statement

Re: Combine two formulas to format postal codes

Re: Help with basic IF statement

Re: Help with basic IF statement

Re: Help with basic IF statement

Re: Help with basic IF statement