About FrankSourced

FrankSourced · 04-20-2022

Hi All,There may be an easy solution to this but I haven't come up with it. I have two comma delimited fields that come in via Shopify for my orders. The first is line items of the order, the second is quantities of each line item.There can be 4-5 li...

FrankSourced · 03-21-2022

Hi Everyone! I've been working with AppSheet for a couple of months but many things still escape me! I have two tables: A table of bartenders (Bartenders Table) and a table of events (Events Table)I would like to: Select multiple bartenders from the ...

FrankSourced · 04-20-2022

I figured it out! INDEX() is what I was looking for: IF(CONTAINS([Line Items Title], ","),CONCATENATE(CONCATENATE(INDEX([Line Items QTY Split],1),"X ",INDEX([Line Items Split],1)),"WITH",CONCATENATE(INDEX([Line Items QTY Split],2),"X ",INDEX([Line It...

FrankSourced · 03-22-2022

Can you expand how I would need to change my schema to achieve this?

FrankSourced · 03-21-2022

Thank you for your prompt reply! The latter is the intended workflow. Meaning:I have event A in New York, I want to select all New York based bartenders and send them an inquiry with the info for event A to invite their participation.So on for event ...

My Stats

FrankSourced's Bio

Badges FrankSourced Earned

Recent Activity

Split and Concatenate List Items in Two Seperate Columns

SMS Multiple People Information From A Separate Table

Re: Split and Concatenate List Items in Two Seperate Columns

Re: SMS Multiple People Information From A Separate Table

Re: SMS Multiple People Information From A Separate Table