thats my function snippet, hope it helps:

-- inserts a row into public.users
create function public.handle_new_user() returns trigger language plpgsql security definer
set
  search_path = public as $$
begin
  insert into public.profiles (user_id, first_name, last_name)
  values (
    new.id, 
    new.raw_user_meta_data->>'first_name', 
    new.raw_user_meta_data->>'last_name'
  );
  return new;
end;
$$;
-- trigger the function every time a user is created
create trigger on_auth_user_created
after
insert
  on auth.users for each row execute procedure public.handle_new_user();

@User and @User please move this into a thread

ok

Is there a reason why the magic-link email has no template?

My dashboard shows one

I've made a new schema and table via the Supabase UI sign SQL. But I'm unable to enable Replication for the new table as it doesn't show in the list. Are there permissions I need to apply to the new schema/table? Cheers!

Hey everyone! I'm attempting to implement row level security, and coming from a mongo background this is confusing me! Say I have a table called "shop_locations" (id, name, shopID) and I can only insert the row if my user ID is stored in "shops_access" (id, userID, shopID).. Im not sure how you reference the about to be inserted shop Id when you're checking in the access table? I've googled for hours so any help would be much appreciated!!

This is interesting - I can't see it lol - I have

SMS Message

,

Confirm Signup

,

Reset password

,

Change email address

and

Invite user

Ah, interesting - "Enable Email Signup" needs to be active in the configuration, otherwise it is not visible.. I intention was to only allow login via magic the link, not have a signup

https://app.supabase.io/api/login and other paths are down

remove

/api/login

from the URL

Works now

I'm trying to do a bulk insert with a variable like this

testList = {date: '2021-11-27'}, {date: '2021-11-28'};

async function insertTime(){
const { data, error } = await supabase
  .from('test')
  .insert([
    testList
  ])

}

But it's only putting the first date in . Is there a better way to do this? Thanks in advance

Try testList = [{},{}] .insert(testList)

ah ha! it worked. Can't believe i wasn't seeing those brackets

Thank you!

I am unable to create a new Supabase project atm. Every time i press "New project" from the dashboard and select an organization I end up on a 404 page.

My work colleague is experiencing that same thing.

Found it in the docs (should have looked harder): https://supabase.com/docs/guides/auth#tips -- add a table to the publication alter publication supabase_realtime add table products; Just need to fix the permissions now for the schema/table.

Does anybody know how to make a table in JavaScript that is populated by a Superbase table?

Supabase's session isn't refreshing correctly, when I call supabase.auth.user() after returning to the website following a time of inactivity, it's null until the next page refresh. Does anyone know how to gracefully solve this?

there is a thread about this: "Access to supabase.auth.user() on initial load" - take a look at it, there is a workaround at the bottom of it

Yeah, I just found it, thanks!

Meanwhile an elegant solution wasn't found, right?

Wish there was some promise based solution...

there are a couple of issue opened about it, you can track them if you want: https://github.com/supabase/ui/issues/291 and https://github.com/supabase/gotrue-js/issues/143

Alright, thanks. It seems to me that your solution was react based, I'm going to study it a bit better and make a more general one

Hey everyone! I'm attempting to implement row level security, and coming from a mongo background this is confusing me! Say I have a table called "shop_locations" (id, name, shopID) and I can only insert the row if my user ID is stored in "shops_access" (id, userID, shopID).. Im not sure how you reference the about to be inserted shop Id when you're checking in the access table? I've googled for hours so any help would be much appreciated!!

Is your userID the authID or do you have a seperate users table?

If it's the auth id, user() in SELECT ( shops_access.userID (not sure of the field here) from shops_access where shops_access.shopID = shop_locations.shopID )