9/7/2023 0 Comments Filemaker pro 14 serial number![]() ![]() In the interim another salesperson has the same circumstance and his order has been registered in FileMaker go as 101. The order they just finished has been logged in by FileMaker go as order number 101. There location does not provide wifi and in addition they are in a mobile telephone dead area. Upon agreement from customers they present the contract, swipe the credit card, get the signature on the iPad. As an example lets say we have 5 sales people working outside the office using iPads to take orders. I selected the option to ignore the error, to leave all the data stored as text, with the intention of preserving the trailing zeros.Īlas, the issue persists.Figure 1.1 Filemaker Pro Function Review – Auto-Enter Serial Number ![]() All the cells in the courseID.personID column gave a "number stored as text error", with the option to convert the text to numbers. Then, I did a Paste Special from my original data, and selected Paste as Values. ![]() I first noticed this was happening, and was very careful to go back to Excel and make a new file (to start fresh), select all cells and set format to Text. I am matching the Excel field to the FMP field. 120, and so courseID.personID becomes something like "123.120". ![]() Some "personID" values end in a zero, e.g. The field in my Excel file is formed similarly, using Excel formulae. To explain further: the field in the database is a calculated text field, "courseID.personID", determined by concatenating the numerical "courseID" and "personID" fields (with a dot in between them). When importing, FMP does not match the fields correctly, because it ignores the trailing zeros. However, the field that I am using to match occasionally contains trailing zeros. I am using the imported data to "Update matching records in found set". I am importing data from an Excel file into a Filemaker Pro database (FMP 12.0 v5 for Mac). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |