Support » Plugin: GravityExport Lite (Gravity Forms Entries in Excel) » Export label instead of value revisited

  • Resolved verysiberian

    (@verysiberian)


    Hello, I tried using the snippet you provided here:

    https://wordpress.org/support/topic/use-label-instead-of-value-in-export/

    However, it seems that the user had trouble with it and you resolved the issue behind the scenes. Would you please share the resolution here? I have the exact same need: I have three user fields that are exporting user IDs instead of the labels (user names). Thank you very much for your excellent plugin and for continuing to support it!

    Best regards,
    Rob

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author GravityKit

    (@gravityview)

    Hi Rob, sorry for missing your question! I’ve asked Doeke to add his solution here.

    Thread Starter verysiberian

    (@verysiberian)

    Thanks, that would be great!

    Plugin Author Doeke Norg

    (@doekenorg)

    Hi @verysiberian,

    Sorry for missing this question. I’m not sure why, but I’m not always getting notified by WordPress about these issues.

    Could you tell me what type of field you’re using? Or even better; send me a json export of the form so I can import it locally. Would help me figure out the exact code you need.

    You can send it to wordpress@doeken.org

    Thanks!

    Thread Starter verysiberian

    (@verysiberian)

    Sorry for the delay. I have so many forms that it took me a bit to remember which one this was! I emailed it to you. I think the issue may be that the three user fields are Gravity Flow user fields, but if there’s a way to fix them in the export, that would be extremely cool.

    Best regards,
    Rob

    Plugin Author Doeke Norg

    (@doekenorg)

    Hi @verysiberian, thanks for providing the data. You are correct about the workflow_user fields. These export the user id by default on a simple export.

    A quick workaround for you would be to add the following snippet to your functions.php.

    add_action( 'gfexcel_field_value_workflow_user', function ( $value, array $entry, \Gravity_Flow_Field_User $field ) {
    	return $field->get_value_export( $entry, $field->id, true );
    }, 10, 3 );

    Or, in case you also want a reference to the user id to remain, you can go for this:

    add_action( 'gfexcel_field_value_workflow_user', function ( $value, array $entry, \Gravity_Flow_Field_User $field ) {
    	return sprintf( '%s (%d)', $field->get_value_export( $entry, $field->id, true ), $value );
    }, 10, 3 );

    This last one will return the value like User name (72), where 72 is the user id.

    Hope this helps you out.

    Thread Starter verysiberian

    (@verysiberian)

    Thank you very much! This is great and should do the trick.

    Best regards,
    Rob (Very Siberian)

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Export label instead of value revisited’ is closed to new replies.