Changing boolean value from form to another value before posting to database

Permanently deleted user

November 24, 2014 20:50

I am hoping someone can help me with this. I currently have a form that has a few check boxes on it. The check boxes are boolean values that equal to -1 (true) and 0 (false), to handle this I simply set up a domain value for the field in the database to equate to "yes" or "no" respectively. Well this seems to work fine in reporting and all other functions. The only problem I am having is when someone exports the table to an excel file or CSV. The final spreadsheet will have the -1 or 0 instead of yes or no. I know that this can be handled through resolving coded domains but I don't believe I have the version that supports this. Therefore, I would just like to reassign the values in the workflow before they are posted to the database.

I am guessing that this can be handled through an assign function but im just not sure how to go about it.  Thanks!

0

• 

  Permanently deleted user

  November 25, 2014 01:59

  I fixed this by just converting the boolean value to a string, and putting that in the database instead. I guess I just way over thought this one.

  0
• 

  Berend Veldkamp

  November 25, 2014 20:33

  That's one way. If you prefer yes/no over true/false, you could use If(MyBooleanValue, "Yes", "No")

  0

Please sign in to leave a comment.