Lightning0114
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Insert link in Email Notification
Hi. I'd like to insert a MS form link in a notification where the receiver will just click on "Click here" and then they will be redirected to the MS form in another tab. Any idea how should we get this done? ------------------------------ Ma. Isabel Gumanid ------------------------------Insert link in Email Notification
Hi. I'd like to insert a MS form link in a notification where the receiver will just click on "Click here" and then they will be redirected to the MS form in another tab. Any idea how should we get this done? ------------------------------ Ma. Isabel Gumanid ------------------------------Webhook or Pipelines for Transferring files content from 1 table to another
Hi, I'm trying to find a way to get out of a manual process of downloading, consolidating and uploading file to QB. As you can see the image below, we have a column called File. From Table 1, what we do is download each file and consolidate them into one file which we upload to Table 2. Can you please suggest ways to make this easier? Still starting with Webhook/Pipelines and not sure if either can do it or what would work better. Thank you! Table 1 Table 2 ------------------------------ Ma. Isabel Gumanid ------------------------------Arrange order of field choices
Hello. I have a table containing different projects with each having 12 months and a corresponding value for each month. Then I set up this lookup field Month which is a reference proxy from that table and while the order of months is "ascending", I would like this Month field to show the order from January to December regardless of the project chosen. Can you please help with this? Should I add a formula on the form? #Tablesandfields #formulas #FormRule ------------------------------ Ma. Isabel Gumanid ------------------------------Arrange order of field choices
Hello. I have a table containing different projects with each having 12 months and a corresponding value for each month. Then I set up this lookup field Month which is a reference proxy from that table and while the order of months is "ascending", I would like this Month field to show the order from January to December regardless of the project chosen. Can you please help with this? Should I add a formula on the form? #Tablesandfields #formulas #FormRule ------------------------------ Ma. Isabel Gumanid ------------------------------Formula-User field that shows value of another Nonempty user field
#field #Formulaandfunctions Hi. I have a formula user field FINAL USER that should show the User A if "User A" field is nonempty, else it should show User B, but if User B field is empty, it should show User C. If User C is empty, it should finally show User D. If I have this: If ( IsNull ([User A]), [User B],[User A]), then it works. However, I need to be able to have the conditions below in that FINAL USER field. Can you please help with the formula? If( IsNull([User A]), [User B],[User A], IsNull([User B]), [User C],[User B], IsNull([User C]), [User D],[User C] ) ------------------------------ Isabel Gumanid ------------------------------Re: Formula text field to return ID of a user
Thanks for getting back to this. We don't have "Supervisor ID" field as we only have the "ID" field which is the ID of everyone regardless of their position. So, for each record, we have the agent's full name and the ID would reflect that of the agent's. In that same record, the agent has the Supervisor name and I wanna add a formula field "Supervisor ID" beside Supervisor that should show the ID of the Supervisor. Is that possible? ------------------------------ Ma. Isabel Gumanid ------------------------------
