KatyKaty
Qrew Trainee
Joined 7 years ago
User Profile
User Widgets
Contributions
Problem adding new user
Can anyone advise regarding adding new users? We have a new staff member starting and it does not seem to be working. Normally I just add them and then they receive an email invite. No emails are being received. I have also tried just using the email address to set up a new account that way but again, this requires verification but no emails are being received. I have obviously checked junk etc. I have done this many times in the past so not sure what the problem is? Any advice appreciated Thanks32Views2likes6CommentsRe: Can I create a field which looks up data from another record within the same table?
Thanks Mark, I've managed to set up the new field which would allow users to select the previous tariff from a drop down menu of all tariffs which relate to the appropriate supply. Is there any way to create a field which would automatically populate the correct previous tariff? I would rather avoid users having to select it manually if at all possible. I was thinking something along the lines of matching the current tariff start date with the previous tariff's end date (+1 day). So if the current tariff has a start date of 1st Jan 16, the field would automatically find and populate with the tariff (for the same supply) which has an end date of (1st Jan 16 - 1 Day = 31st Dec 15). Do you think this is feasible? Thanks5Views0likes0CommentsCan I create a field which looks up data from another record within the same table?
Hi there, I'm new to this so bear with me.... I have a table for "Supplies", and a table for "Tariffs". Each supply can have many tariffs (but only one is "live" at any given time). Is there a way to add a field to my Tariffs table which would provide detail from the previous tariff? So for example, Tariff 1 might be for the period 1 Jan 15 - 31 Dec 15 and be provided by "Supplier A", and Tariff 2 would be for the period 1 Jan 16 - 31 Dec 16 and be provided by "Supplier B". In the record for Tariff 2, I would like there to be a field called "Previous Supplier" which for this example would provide the value "Supplier A". Any thoughts / advice appreciated!