At the moment if I wanted to import existing data into a new account, one that I’ve set up as a Ragic Partner, (importing into a template design of mine). I would need to delete and replace with new (free text field) any “select from other sheet” fields that I would like to import into, as the field “type” cannot be changed.
Guys>>>>>>>>>>> Is there another way of doing this? I am getting it right here? I was wondering…
Anyway, I can work around the fact that the field type on those 'select from other sheet" fields can’t have their field type changed. For the cases when it’s a new account that requires importing data.
I hope to get this ironed out (the whole importing data procedure) for the real-estate template design of mine www.ragic.com/housedbdemo
I also use the same design every day for my family’s business, but probably won’t need uploading any data into that account www.ragic.com/househunters
But say I did, or should one of the new account that I hope to create, suppose later on they require importing data…at a later stage.
The initial importing I could do for them, and so use the work around mentioned, but in the case of the accounts that I create and set up, if they were to require importing of data at a later date, the process may not be clear to see, in other words the “customer” could unknowingly fall into trouble, not knowing that the fields need to be deleted and replaced, and the initial data removed and re-imported…
That’s my thought son this one guys, I would not mind hearing what you guys think?
I don’t know how important you may think this is, or even if it can be fixed in the first place, but as I ma learning still I may not yet understand that anything I possible when it comes to programming business intelligence, something that I know those at Ragic profess to as well.
Maybe I’m wrong here, and you cannot and should not be able to change the field type to “free text” for those “select from other sheet fields” for the initial importing of data, where in my example, I would like to then run a temporary link and load, in fact, to the same sheet that I was going to and intend to later use as the “select from another sheet” field again.
If you would like to have a look the sheet is the Property’s: Owner and Contacts sheet https://www.ragic.com/housedbdemo/properties/67
With a temp link and load from the Contacts sheet below (after having imported corresponding “new” data into both sheets) https://www.ragic.com/housedbdemo/properties/70