Skip to main content
Question

Field Issue With a Pipeline

  • December 9, 2022
  • 0 replies
  • 35 views
Forum|alt.badge.img+5
Hello,

I'm having an issue with a number my pipeline is pulling over, it changes the number. I have one app where a 19 digit ID is put into a record. When my pipeline pulls that record and creates a new record in a different app it changes the number. I have tried changing the field type on the second app but it is not working. Please help.

This is the ID in the first app.
but it pulls it over with this number.


------------------------------
Fatima Khan
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • December 9, 2022
    A good rule of thumb for deciding if as field should be text or numeric is that if it's not going to be used for calculations, then it should be a text field.  Quickbase only retains accuracy on numeric fields for 13 digits.

    I suggest that you make the target field a text field and if you can change the source field to be text that would be best but if not, then try making a new field called ToText([my big numeric field]) in the source table  and use that for the source of the Pipeline.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement