Method General Q & A

Re: Drop down menu - Linked Fields

Method_Ben — Fri, 21 Apr 2017 20:23:33 GMT

Hi there Samy,

It sounds like you are doing everything correctly by what you are describing, But I would have to take a look at your Table structure and the screens in question to give you a better answer here.

Can you shoot me an email at Success@method.me - ( For Ben as the subject ).

If you can tell me the name of your account, and the screen you are trying to customize thats giving you this datatype conversion error, Ill jump in and see what I can find.

Thanks Samy!

-Ben

Re: Drop down menu - Linked Fields

samy — Fri, 21 Apr 2017 18:51:44 GMT

anyone can help me please ?

Drop down menu - Linked Fields

samy — Thu, 20 Apr 2017 18:35:59 GMT

Hello,

I've added a field to the Contacts table so I'll be able to assign credits to my clients for their hours. I've titled that field "Contract Hours."

On another table that I created, I've added a drop-down based on the Contacts table, and I added "Contract Hours" as a linked field (which I named "Contract hours1"). I thought that "Contract hours1" would refer to the value of the "Contract Hours" field in the Contacts table. But for me, linked fields--such as "contract hours1"--are just there. I haven't been able to do any math functions using its value, and when I try to retrieve the value of "Contract Hours" which is located at the Contacts Table and place it in any other field on another table (using an action). I get the following message: "Error Retrieving Value from Table ->Error converting data type varchar to numeric."

What I am trying to do is to create a field in the Contacts table that contains the number of hours that the client purchased. then when I perform any service for that client, I would deduct the amount of time that I spent from the "contract hours" field and then store it in another field which represents the remaining balance.

If anyone has a better or a simpler logic structure, please let me know.

Thank you in advance.