SergioSergio
7 years agoQrew Cadet
Re: pull information from a field in another table from the respective field based on the month of the year
Mark, not yet.
I think there is something missing.
Its probably easier for you to understand if you were able to see the video. I dont understand why you cant if I didnt restrict the region.
Anyways, I created the records, one for each month with the interest rate for each month.
In the other table where I have the transactions, each transactions has its value, and its interest rate according which month it is.
What I needed is if I have 100 transactions on Jan, the interest rate would be whatever the interest rate it is on the interest rate table.
Right now the way I do is, change the default value of that field in the begining of the month, so every record I import after that date, will have that default value on the rate.
Even the guys on the quickbase support team were not able to get that working for me.
I think there is something missing.
Its probably easier for you to understand if you were able to see the video. I dont understand why you cant if I didnt restrict the region.
Anyways, I created the records, one for each month with the interest rate for each month.
In the other table where I have the transactions, each transactions has its value, and its interest rate according which month it is.
What I needed is if I have 100 transactions on Jan, the interest rate would be whatever the interest rate it is on the interest rate table.
Right now the way I do is, change the default value of that field in the begining of the month, so every record I import after that date, will have that default value on the rate.
Even the guys on the quickbase support team were not able to get that working for me.