About Gustavo_Leiva

Gustavo_Leiva · 12-28-2021

Hello, I am trying to partition a workbook consisting of audits based on Audit day and have the user click on the scheduled day. I tested with Monday and Friday. I created a Usersetting option named ‘Available Days’. Then flagged ‘Partitioned across ...

Gustavo_Leiva · 11-19-2021

Hello, I am building a app with a significant number of rows. Since it goes over the 100,000 rows, I split the data into different days an operation/service will run by. One app per day of the week. All 5 apps tap into a single workbook with separate...

Gustavo_Leiva · 11-03-2021

Hello, I am working through an app has the user enter the mileage at the start and end of day. I’d like the starting mileage entry to be populated with the previous mileage for that truck. I have 2 tables, Mileage Form and Trucks. [Truck Number] from...

Gustavo_Leiva · 06-23-2021

Hello, I am hoping for some assistance/insight as to what may be happening with my form. I have created 3 section headers. Each section to be filled in by 1 individual. When person A fills out section A, he/she saves the form and Person B gets a noti...

Gustavo_Leiva · 04-15-2021

Hello, I was able to generate Image URL via a virtual column setup in a form: However, I am aiming towards writing the link to the spreadsheet along with the data being inputted by the user. I attempted on adding the column to the spreadsheet and emb...

Gustavo_Leiva · 11-22-2021

Thank you Steve and @WillowMobileSystems for the help! Think this is exactly what I was looking for. By partitioning, I can exclude those days that I will not be needing anymore accordingly, thus having the app not pull irrelevant data back and forth...

Gustavo_Leiva · 11-22-2021

Will research this concept and circle around if I have any questions! Thank you!

Gustavo_Leiva · 11-19-2021

Thank you for replying! The answer is yes. This app is a one time thing and only for a week. Essentially, what we are using the app for is to track the progress of a deployment of deliverables(Delivery Complete,Skipped,etc). Instead of having the one...

Gustavo_Leiva · 11-04-2021

Hello Steve, Please disregard today’s replies. I continued reading the very helpful thread you shared with me and was able to put together the expression that gave me the results I wanted! LOOKUP( MAX( SELECT( Mileage Tracker[_ROWNUMBER], ([_THISROW]...

Gustavo_Leiva · 11-04-2021

Thank you Steve for your guidance! I modified the formula above because the value I am trying to pull is not from another table but from the current table the form is adding rows to. I was positive the expression below would work because the green ch...

My Stats

tuple's Bio

Badges Gustavo_Leiva Earned

Recent Activity

Data Partitioning based on week day

Different Tabs vs Separate Workbooks

Populating starting mileage with previous recorded mileage

Form Section Headers appearing at the bottom of the form after saving and reopening

Writing Direct Image URL to spreadsheet

Re: Different Tabs vs Separate Workbooks

Re: Different Tabs vs Separate Workbooks

Re: Different Tabs vs Separate Workbooks

Re: Populating starting mileage with previous recorded mileage

Re: Populating starting mileage with previous recorded mileage