Jump to content

Calculated field


This topic is 6938 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, i'm doing a calculation field but i want to add conditional steps in the calculation.

This is for bibliographical references. My calculation is this:

TextStyleAdd ( AuteurNom; Uppercase) & ", " & AuteurPrenom & ", " & TextStyleAdd (Titre; Italic) & ", " & Reference & ", " & Annee

My problem is that if I don't have data in all the fields, it looks something like this: LASTNAME, , Title, , Year.

I'd like to find a way to add a comma only if the field before it is not empty.

So the same exemple will look like this : LASTNAME, Title, year

I pretty sure I can do something with the isempty function, but, i'm not exactly sure how.

Help would be appreciated

Link to comment
Share on other sites

Along the lines you are suggesting replace the first "," by

If(IsEmpty(AuteurNom);"";",")

the second by

If(IsEmpty(AuteurPrenom);"";",")

the third by

If(IsEmpty(Titre);"";",")

and finally the last by

If(IsEmpty(Annee);"";",")

Link to comment
Share on other sites

This topic is 6938 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.